/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50741
Source Host           : 127.0.0.1:3306
Source Database       : tyfast

Target Server Type    : MYSQL
Target Server Version : 50741
File Encoding         : 65001

Date: 2025-06-24 15:58:06
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_city`
-- ----------------------------
DROP TABLE IF EXISTS `t_city`;
CREATE TABLE `t_city` (
`city_id`  varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '城市ID' ,
`province_id`  varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省ID' ,
`city_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市名称' ,
`flag`  int(1) NOT NULL DEFAULT 2 COMMENT '标识(1=直辖市；2=地级市；3=县级市)' ,
`remark`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`city_id`),
FOREIGN KEY (`province_id`) REFERENCES `t_province` (`province_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `idx_city_ref_province` (`province_id`) USING BTREE ,
INDEX `idx_flag` (`flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='市'

;

-- ----------------------------
-- Records of t_city
-- ----------------------------
BEGIN;
INSERT INTO `t_city` VALUES ('000200', '000222', '台北市', '2', ''), ('000210', '000222', '新北市', '2', null), ('000220', '000222', '桃园市', '2', null), ('000230', '000222', '台中市', '2', null), ('000240', '000222', '台南市', '2', null), ('000250', '000222', '高雄市', '2', null), ('010000', '010000', '呼和浩特市', '2', null), ('012000', '010000', '乌兰察布市', '2', null), ('014000', '010000', '包头市', '2', null), ('015000', '010000', '巴彦淖尔市', '2', null), ('016000', '010000', '乌海市', '2', null), ('017000', '010000', '鄂尔多斯市', '2', null), ('021000', '010000', '呼伦贝尔市', '2', null), ('024000', '010000', '赤峰市', '2', null), ('026000', '010000', '锡林郭勒盟', '2', null), ('028000', '010000', '通辽市', '2', null), ('030000', '030000', '太原市', '2', ''), ('030600', '030000', '晋中市', '2', null), ('033000', '030000', '吕梁市', '2', null), ('034000', '030000', '忻州市', '2', null), ('036000', '030000', '朔州市', '2', null), ('037000', '030000', '大同市', '2', null), ('041000', '030000', '临汾市', '2', null), ('044000', '030000', '运城市', '2', null), ('045000', '030000', '阳泉市', '2', null), ('046000', '030000', '长治市', '2', null), ('048000', '030000', '晋城市', '2', null), ('050000', '050000', '石家庄市', '2', null), ('053000', '050000', '衡水市', '2', null), ('054000', '050000', '邢台市', '2', null), ('056000', '050000', '邯郸市', '2', null), ('061000', '050000', '沧州市', '2', null), ('063000', '050000', '唐山市', '2', null), ('065000', '050000', '廊坊市', '2', null), ('066000', '050000', '秦皇岛市', '2', null), ('067000', '050000', '承德市', '2', null), ('071000', '050000', '保定市', '2', null), ('075000', '050000', '张家口市', '2', null), ('100000', '100000', '北京市', '1', '首都'), ('110000', '110000', '沈阳市', '2', null), ('111000', '110000', '辽阳市', '2', null), ('112000', '110000', '铁岭市', '2', null), ('113000', '110000', '抚顺市', '2', null), ('114000', '110000', '鞍山市', '2', null), ('115000', '110000', '营口市', '2', null), ('116000', '110000', '大连市', '2', null), ('117000', '110000', '本溪市', '2', null), ('118000', '110000', '丹东市', '2', null), ('121000', '110000', '锦州市', '2', null), ('122000', '110000', '朝阳市', '2', null), ('123000', '110000', '阜新市', '2', null), ('124000', '110000', '盘锦市', '2', null), ('125000', '110000', '葫芦岛市', '2', null), ('130000', '130000', '长春市', '2', null), ('132000', '130000', '吉林市', '2', null), ('133000', '130000', '延边朝鲜族自治州', '2', null), ('134000', '130000', '通化市', '2', null), ('134300', '130000', '白山市', '2', null), ('136000', '130000', '四平市', '2', null), ('136200', '130000', '辽源市', '2', null), ('137000', '130000', '白城市', '2', null), ('137400', '010000', '兴安盟', '2', null), ('138000', '130000', '松原市', '2', null), ('150000', '150000', '哈尔滨市', '2', null), ('152000', '150000', '绥化市', '2', null), ('153000', '150000', '伊春市', '2', null), ('154000', '150000', '佳木斯市', '2', null), ('154100', '150000', '鹤岗市', '2', null), ('154600', '150000', '七台河市', '2', null), ('155100', '150000', '双鸭山市', '2', null), ('157000', '150000', '牡丹江市', '2', null), ('158100', '150000', '鸡西市', '2', null), ('161000', '150000', '齐齐哈尔市', '2', null), ('163000', '150000', '大庆市', '2', null), ('164300', '150000', '黑河市', '2', null), ('165000', '150000', '大兴安岭地区', '2', null), ('200000', '200000', '上海市', '1', null), ('210000', '210000', '南京市', '2', null), ('212000', '210000', '镇江市', '2', null), ('213000', '210000', '常州市', '2', null), ('214000', '210000', '无锡市', '2', null), ('215000', '210000', '苏州市', '2', null), ('215300', '210000', '泰州市', '2', null), ('221000', '210000', '徐州市', '2', null), ('222000', '210000', '连云港市', '2', null), ('223001', '210000', '淮安市', '2', null), ('223800', '210000', '宿迁市', '2', null), ('224000', '210000', '盐城市', '2', null), ('225000', '210000', '扬州市', '2', null), ('226000', '210000', '南通市', '2', null), ('230000', '230000', '合肥市', '2', null), ('232000', '230000', '淮南市', '2', null), ('233000', '230000', '蚌埠市', '2', null), ('234000', '230000', '宿州市', '2', null), ('235000', '230000', '淮北市', '2', null), ('236000', '230000', '阜阳市', '2', null), ('236800', '230000', '亳州市', '2', null), ('237000', '230000', '六安市', '2', null), ('238000', '230000', '巢湖市', '2', null), ('239000', '230000', '滁州市', '2', null);
INSERT INTO `t_city` VALUES ('241000', '230000', '芜湖市', '2', null), ('242000', '230000', '宣城市', '2', null), ('243000', '230000', '马鞍山市', '2', null), ('244000', '230000', '铜陵市', '2', null), ('245000', '230000', '黄山市', '2', null), ('246000', '230000', '安庆市', '2', null), ('247100', '230000', '池州市', '2', null), ('250000', '250000', '济南市', '2', null), ('252000', '250000', '聊城市', '2', null), ('253000', '250000', '德州市', '2', null), ('255000', '250000', '淄博市', '2', null), ('256600', '250000', '滨州市', '2', null), ('257000', '250000', '东营市', '2', null), ('261000', '250000', '潍坊市', '2', null), ('264000', '250000', '烟台市', '2', null), ('264200', '250000', '威海市', '2', null), ('266000', '250000', '青岛市', '2', null), ('271000', '250000', '泰安市', '2', null), ('271100', '250000', '莱芜市', '2', null), ('272000', '250000', '济宁市', '2', null), ('274000', '250000', '菏泽市', '2', null), ('276000', '250000', '临沂市', '2', null), ('276800', '250000', '日照市', '2', null), ('277000', '250000', '枣庄市', '2', null), ('300000', '300000', '天津市', '1', null), ('310000', '310000', '杭州市', '2', null), ('312000', '310000', '绍兴市', '2', null), ('313000', '310000', '湖州市', '2', null), ('314000', '310000', '嘉兴市', '2', null), ('315000', '310000', '宁波市', '2', null), ('316000', '310000', '舟山市', '2', null), ('318000', '310000', '台州市', '2', null), ('321000', '310000', '金华市', '2', null), ('323000', '310000', '丽水市', '2', null), ('324000', '310000', '衢州市', '2', null), ('325000', '310000', '温州市', '2', null), ('330000', '330000', '南昌市', '2', null), ('332000', '330000', '九江市', '2', null), ('333000', '330000', '景德镇市', '2', null), ('334000', '330000', '上饶市', '2', null), ('335000', '330000', '鹰潭市', '2', null), ('336000', '330000', '宜春市', '2', null), ('337000', '330000', '萍乡市', '2', null), ('338000', '330000', '新余市', '2', null), ('341000', '330000', '赣州市', '2', null), ('343000', '330000', '吉安市', '2', null), ('344000', '330000', '抚州市', '2', null), ('350000', '350000', '福州市', '2', null), ('351100', '350000', '莆田市', '2', null), ('352000', '350000', '宁德市', '2', null), ('353000', '350000', '南平市', '2', null), ('361000', '350000', '厦门市', '2', null), ('362000', '350000', '泉州市', '2', null), ('363000', '350000', '漳州市', '2', null), ('364000', '350000', '龙岩市', '2', null), ('365000', '350000', '三明市', '2', null), ('400000', '400000', '重庆市', '1', null), ('410000', '410000', '长沙市', '2', null), ('411100', '410000', '湘潭市', '2', null), ('412000', '410000', '株洲市', '2', null), ('413000', '410000', '益阳市', '2', null), ('414000', '410000', '岳阳市', '2', null), ('415000', '410000', '常德市', '2', null), ('416000', '410000', '湘西土家族苗族自治州', '2', null), ('417000', '410000', '娄底市', '2', null), ('418000', '410000', '怀化市', '2', null), ('421200', '410000', '衡阳市', '2', null), ('422000', '410000', '邵阳市', '2', null), ('423000', '410000', '郴州市', '2', null), ('425000', '410000', '永州市', '2', null), ('427000', '410000', '张家界市', '2', null), ('430000', '430000', '武汉市', '2', null), ('431700', '430000', '天门市', '3', null), ('432000', '430000', '孝感市', '2', null), ('433000', '430000', '仙桃市', '3', null), ('433100', '430000', '潜江市', '3', null), ('434000', '430000', '荆州市', '2', null), ('435000', '430000', '黄石市', '2', null), ('436000', '430000', '鄂州市', '2', null), ('437000', '430000', '咸宁市', '2', null), ('438000', '430000', '黄冈市', '2', null), ('441000', '430000', '襄樊市', '2', null), ('441300', '430000', '随州市', '2', null), ('442000', '430000', '十堰市', '2', null), ('442400', '430000', '神农架林区', '3', null), ('443000', '430000', '宜昌市', '2', null), ('445000', '430000', '恩施土家族苗族自治州', '2', null), ('448000', '430000', '荆门市', '2', null), ('450000', '450000', '郑州市', '2', null), ('453000', '450000', '新乡市', '2', null), ('454150', '450000', '焦作市', '2', null), ('454650', '450000', '济源市', '3', null), ('455000', '450000', '安阳市', '2', null), ('457000', '450000', '濮阳市', '2', null), ('458000', '450000', '鹤壁市', '2', null), ('461000', '450000', '许昌市', '2', null), ('462000', '450000', '漯河市', '2', null), ('463000', '450000', '驻马店市', '2', null), ('464000', '450000', '信阳市', '2', null), ('466000', '450000', '周口市', '2', null);
INSERT INTO `t_city` VALUES ('467000', '450000', '平顶山市', '2', null), ('471000', '450000', '洛阳市', '2', null), ('472000', '450000', '三门峡市', '2', null), ('473000', '450000', '南阳市', '2', null), ('475000', '450000', '开封市', '2', null), ('476000', '450000', '商丘市', '2', null), ('476600', '450000', '永城市', '3', null), ('510000', '510000', '广州市', '2', null), ('511500', '510000', '清远市', '2', null), ('512000', '510000', '韶关市', '2', null), ('514000', '510000', '梅州市', '2', null), ('515000', '510000', '汕头市', '2', null), ('516000', '510000', '惠州市', '2', null), ('516600', '510000', '汕尾市', '2', null), ('517000', '510000', '河源市', '2', null), ('518000', '510000', '深圳市', '2', null), ('519000', '510000', '珠海市', '2', null), ('521000', '510000', '潮州市', '2', null), ('522000', '510000', '揭阳市', '2', null), ('523000', '510000', '东莞市', '2', null), ('524000', '510000', '湛江市', '2', null), ('525000', '510000', '茂名市', '2', null), ('526000', '510000', '肇庆市', '2', null), ('527300', '510000', '云浮市', '2', null), ('528000', '510000', '佛山市', '2', null), ('528400', '510000', '中山市', '2', null), ('529000', '510000', '江门市', '2', null), ('529500', '510000', '阳江市', '2', null), ('530000', '530000', '南宁市', '2', null), ('532200', '530000', '崇左市', '2', null), ('533000', '530000', '百色市', '2', null), ('535000', '530000', '钦州市', '2', null), ('536000', '530000', '北海市', '2', null), ('537000', '530000', '玉林市', '2', null), ('537100', '530000', '贵港市', '2', null), ('538000', '530000', '防城港市', '2', null), ('541000', '530000', '桂林市', '2', null), ('542800', '530000', '贺州市', '2', null), ('543000', '530000', '梧州市', '2', ''), ('545000', '530000', '柳州市', '2', null), ('546100', '530000', '来宾市', '2', null), ('547000', '530000', '河池市', '2', null), ('550000', '550000', '贵阳市', '2', null), ('551700', '550000', '毕节地区', '2', null), ('553000', '550000', '六盘水市', '2', null), ('554300', '550000', '铜仁地区', '2', null), ('556000', '550000', '黔东南苗族侗族自治州', '2', null), ('558000', '550000', '黔南布依族苗族自治州', '2', null), ('561000', '550000', '安顺市', '2', null), ('562400', '550000', '黔西南布依族苗族自治州', '2', null), ('563000', '550000', '遵义市', '2', null), ('570100', '570100', '海口市', '2', null), ('571200', '570100', '定安县', '3', null), ('571300', '570100', '文昌市', '3', null), ('571400', '570100', '琼海市', '3', null), ('571500', '570100', '万宁市', '3', null), ('571600', '570100', '屯昌县', '3', null), ('571700', '570100', '儋州市', '2', null), ('571800', '570100', '临高县', '3', null), ('571900', '570100', '澄迈县', '3', null), ('572000', '570100', '三亚市', '2', null), ('572200', '570100', '五指山市', '3', null), ('572300', '570100', '保亭黎族苗族自治县', '3', null), ('572400', '570100', '陵水黎族自治县', '3', null), ('572500', '570100', '乐东黎族自治县', '3', null), ('572600', '570100', '东方市', '3', null), ('572700', '570100', '昌江黎族自治县', '3', null), ('572800', '570100', '白沙黎族自治县', '3', null), ('572900', '570100', '琼中黎族苗族自治县', '3', null), ('573199', '570100', '三沙市', '2', null), ('610000', '610000', '成都市', '2', null), ('614000', '610000', '乐山市', '2', null), ('615000', '610000', '凉山彝族自治州', '2', null), ('617000', '610000', '攀枝花市', '2', null), ('618000', '610000', '德阳市', '2', null), ('620000', '610000', '眉山市', '2', null), ('621000', '610000', '绵阳市', '2', null), ('624000', '610000', '阿坝藏族羌族自治州', '2', null), ('625000', '610000', '雅安市', '2', null), ('626700', '610000', '甘孜藏族自治州', '2', null), ('628000', '610000', '广元市', '2', null), ('629000', '610000', '遂宁市', '2', null), ('635000', '610000', '达州市', '2', null), ('636600', '610000', '巴中市', '2', null), ('637000', '610000', '南充市', '2', null), ('638500', '610000', '广安市', '2', null), ('641000', '610000', '内江市', '2', null), ('641300', '610000', '资阳市', '2', null), ('643000', '610000', '自贡市', '2', null), ('644000', '610000', '宜宾市', '2', null), ('646000', '610000', '泸州市', '2', null), ('650000', '650000', '昆明市', '2', null), ('651400', '650000', '红河哈尼族彝族自治州', '2', null), ('653100', '650000', '玉溪市', '2', null), ('655000', '650000', '曲靖市', '2', null), ('657000', '650000', '昭通市', '2', null), ('663000', '650000', '文山壮族苗族自治州', '2', null), ('665000', '650000', '普洱市', '2', null), ('666100', '650000', '西双版纳傣族自治州', '2', null), ('671000', '650000', '大理白族自治州', '2', null);
INSERT INTO `t_city` VALUES ('673100', '650000', '怒江傈僳族自治州', '2', null), ('674100', '650000', '丽江市', '2', null), ('674400', '650000', '迪庆藏族自治州', '2', null), ('675000', '650000', '楚雄彝族自治州', '2', null), ('677000', '650000', '临沧市', '2', null), ('678000', '650000', '保山市', '2', null), ('678400', '650000', '德宏傣族景颇族自治州', '2', null), ('710000', '710000', '西安市', '2', null), ('712000', '710000', '咸阳市', '2', null), ('714000', '710000', '渭南市', '2', null), ('716000', '710000', '延安市', '2', null), ('719000', '710000', '榆林市', '2', null), ('721000', '710000', '宝鸡市', '2', null), ('723000', '710000', '汉中市', '2', null), ('725000', '710000', '安康市', '2', null), ('726000', '710000', '商洛市', '2', null), ('727000', '710000', '铜川市', '2', null), ('730000', '730000', '兰州市', '2', null), ('730900', '730000', '白银市', '2', null), ('731100', '730000', '临夏回族自治州', '2', null), ('733000', '730000', '武威市', '2', null), ('734000', '730000', '张掖市', '2', null), ('735000', '730000', '酒泉市', '2', null), ('735100', '730000', '嘉峪关市', '2', null), ('737100', '730000', '金昌市', '2', null), ('741000', '730000', '天水市', '2', null), ('742500', '730000', '陇南市', '2', null), ('743000', '730000', '定西市', '2', null), ('744000', '730000', '平凉市', '2', null), ('745000', '730000', '庆阳市', '2', null), ('747000', '730000', '甘南藏族自治州', '2', null), ('750000', '750000', '银川市', '2', null), ('750300', '010000', '阿拉善盟', '2', null), ('751100', '750000', '吴忠市', '2', null), ('753000', '750000', '石嘴山市', '2', null), ('755000', '750000', '中卫市', '2', null), ('756000', '750000', '固原市', '2', null), ('810000', '810000', '西宁市', '2', null), ('810600', '810000', '海东地区', '2', null), ('811300', '810000', '黄南藏族自治州', '2', null), ('812200', '810000', '海北藏族自治州', '2', null), ('813000', '810000', '海南藏族自治州', '2', null), ('814000', '810000', '果洛藏族自治州', '2', null), ('815000', '810000', '玉树藏族自治州', '2', null), ('817000', '810000', '海西蒙古族藏族自治州', '2', null), ('830000', '830000', '乌鲁木齐市', '2', null), ('831100', '830000', '昌吉回族自治州', '2', null), ('831300', '830000', '五家渠市', '3', null), ('832000', '830000', '石河子市', '3', null), ('833400', '830000', '博尔塔拉蒙古自治州', '2', null), ('834000', '830000', '克拉玛依市', '2', null), ('834700', '830000', '塔城地区', '2', null), ('835100', '830000', '伊犁哈萨克自治州', '2', null), ('836500', '830000', '阿勒泰地区', '2', null), ('838000', '830000', '吐鲁番地区', '2', null), ('839000', '830000', '哈密地区', '2', ''), ('841000', '830000', '巴音郭楞蒙古自治州', '2', null), ('841007', '830000', '铁门关市', '3', null), ('843000', '830000', '阿克苏地区', '2', null), ('843300', '830000', '阿拉尔市', '3', null), ('843900', '830000', '图木舒克市', '3', null), ('844000', '830000', '喀什地区', '2', null), ('845350', '830000', '克孜勒苏柯尔克孜自治州', '2', null), ('848000', '830000', '和田地区', '2', null), ('850000', '850000', '拉萨市', '2', null), ('852000', '850000', '那曲地区', '2', null), ('854000', '850000', '昌都地区', '2', null), ('856000', '850000', '山南地区', '2', null), ('857000', '850000', '日喀则地区', '2', null), ('859000', '850000', '阿里地区', '2', null), ('860000', '850000', '林芝地区', '2', null), ('999077', '999000', '香港', '2', '香港是中西方文化交融之地，把华人智慧与西方社会管理经验合二为一'), ('999078', '999000', '澳门', '2', null);
COMMIT;

-- ----------------------------
-- Table structure for `t_dictionary`
-- ----------------------------
DROP TABLE IF EXISTS `t_dictionary`;
CREATE TABLE `t_dictionary` (
`code`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典Code' ,
`name`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称' ,
`items`  text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '字典值JSON' ,
`create_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
PRIMARY KEY (`code`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='数据字典'

;

-- ----------------------------
-- Records of t_dictionary
-- ----------------------------
BEGIN;
INSERT INTO `t_dictionary` VALUES ('AUTO-LOGIN', '自动登录账户列表', '[{\"text\":\"adm\",\"value\":\"admin\"}]', '22013040950847000084', '2023-02-02 14:19:17', '22013040950847000084', '2024-09-02 10:35:57'), ('boroughtype', '行政级别', '[{\"text\":\"省\",\"value\":2},{\"text\":\"直辖市\",\"value\":1},{\"text\":\"自治区\",\"value\":3},{\"text\":\"特别行政区\",\"value\":4}]', '22072134602356000007', '2022-10-14 16:23:05', '22013040950847000084', '2023-05-26 11:44:01'), ('gender', '性别', '[{\"text\":\"男\",\"value\":1},{\"text\":\"女\",\"value\":0}]', '22013040950847000084', '2022-10-17 10:11:03', '22013040950847000084', '2022-10-20 11:18:54'), ('userstatus', '用户状态', '[{\"text\":\"正常\",\"value\":0},{\"text\":\"冻结\",\"value\":1}]', '22013040950847000084', '2022-10-17 09:27:13', '22013040950847000084', '2022-10-17 11:26:07'), ('usertype', '用户类型', '[{\"text\":\"系统用户\",\"value\":1},{\"text\":\"普通用户\",\"value\":2}]', '22013040950847000084', '2023-08-04 17:15:27', '22013040950847000084', '2023-08-04 17:16:16');
COMMIT;

-- ----------------------------
-- Table structure for `t_district`
-- ----------------------------
DROP TABLE IF EXISTS `t_district`;
CREATE TABLE `t_district` (
`district_id`  varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '区县ID' ,
`city_id`  varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市ID' ,
`district_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '区县名称' ,
`remark`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`district_id`),
FOREIGN KEY (`city_id`) REFERENCES `t_city` (`city_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `fk_city_ref_district` (`city_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='区县'

;

-- ----------------------------
-- Records of t_district
-- ----------------------------
BEGIN;
INSERT INTO `t_district` VALUES ('000201', '000200', '中正区', null), ('000202', '000200', '中山区', null), ('000203', '000200', '大同区', null), ('000204', '000200', '松山区', null), ('000205', '000200', '万华区', null), ('000206', '000200', '信义区', null), ('000207', '000200', '南港区', null), ('000208', '000200', '文山区', null), ('000209', '000200', '北投区', null), ('000210', '000210', '板桥区', null), ('000211', '000210', '中和区', null), ('000212', '000210', '永和区', null), ('000213', '000210', '土城区', null), ('000214', '000210', '莺歌区', null), ('000215', '000210', '三重区', null), ('000216', '000210', '泰山区', null), ('000217', '000210', '平溪区', null), ('000218', '000210', '新店区', null), ('000219', '000210', '石门区', null), ('000220', '000220', '桃园区', null), ('000221', '000220', '中坜区', null), ('000222', '000220', '平镇区', null), ('000223', '000220', '八德区', null), ('000224', '000220', '芦竹区', null), ('000225', '000220', '大溪区', null), ('000226', '000220', '龟山区', null), ('000227', '000220', '大园区', null), ('000228', '000220', '观音区', null), ('000229', '000220', '新屋区', null), ('000230', '000230', '中区', null), ('000231', '000230', '北屯区', null), ('000232', '000230', '太平区', null), ('000233', '000230', '大里区', null), ('000234', '000230', '乌日区', null), ('000235', '000230', '石冈区', null), ('000236', '000230', '清水区', null), ('000237', '000230', '外埔区', null), ('000238', '000230', '雾峰区', null), ('000239', '000230', '沙鹿区', null), ('000240', '000240', '中西区', null), ('000241', '000240', '南区', null), ('000242', '000240', '北区', null), ('000243', '000240', '安南区', null), ('000244', '000240', '永康区', null), ('000245', '000240', '新化区', null), ('000246', '000240', '左镇区', null), ('000247', '000240', '玉井区', null), ('000248', '000240', '白河区', null), ('000249', '000240', '新市区', null), ('000250', '000250', '楠梓区', null), ('000251', '000250', '左营区', null), ('000252', '000250', '苓雅区', null), ('000253', '000250', '林园区', null), ('000254', '000250', '大树区', null), ('000255', '000250', '桥头区', null), ('000256', '000250', '阿莲区', null), ('000257', '000250', '永安区', null), ('000258', '000250', '内门区', null), ('000259', '000250', '桃源区', null), ('010000', '010000', '新城区', null), ('010001', '010000', '玉泉区', null), ('010010', '010000', '回民区', null), ('010011', '010000', '赛罕区', null), ('010100', '010000', '土默特左旗', null), ('010200', '010000', '托克托县', null), ('011100', '026000', '二连浩特市', null), ('011200', '026000', '苏尼特右旗', null), ('011300', '026000', '苏尼特左旗', null), ('011400', '026000', '阿巴嘎旗', null), ('011500', '010000', '和林格尔县', null), ('011600', '010000', '清水河县', null), ('011700', '010000', '武川县', null), ('011800', '012000', '四子王旗', null), ('012000', '012000', '集宁区', null), ('012100', '012000', '丰镇市', null), ('012200', '012000', '察哈尔右翼前旗', null), ('012300', '012000', '卓资县', null), ('012400', '012000', '察哈尔右翼后旗', null), ('013250', '026000', '镶黄旗', null), ('013350', '012000', '化德县', null), ('013400', '012000', '商都县', null), ('013500', '012000', '察哈尔右翼中旗', null), ('013650', '012000', '兴和县', null), ('013750', '012000', '凉城县', null), ('013800', '026000', '正镶白旗', null), ('014000', '014000', '东河区', null), ('014001', '014000', '九原区', null), ('014002', '014000', '昆都仑区', null), ('014003', '014000', '白云鄂博矿区', null), ('014007', '014000', '青山区', null), ('014070', '014000', '石拐区', null), ('014100', '014000', '土默特右旗', null), ('014200', '014000', '固阳县', null), ('014300', '017000', '达拉特旗', null), ('014400', '015000', '乌拉特前旗', null), ('014500', '014000', '达尔罕茂明安联合旗', null), ('015000', '015000', '临河区', null), ('015100', '015000', '五原县', null), ('015200', '015000', '磴口县', null), ('015300', '015000', '乌拉特中旗', null);
INSERT INTO `t_district` VALUES ('015400', '015000', '杭锦后旗', null), ('015500', '015000', '乌拉特后旗', null), ('016000', '016000', '乌达区', null), ('016001', '016000', '海勃湾区', null), ('016002', '016000', '海南区', null), ('016100', '017000', '鄂托克旗', null), ('016200', '017000', '鄂托克前旗', null), ('017000', '017000', '东胜区', null), ('017100', '017000', '准格尔旗', null), ('017200', '017000', '伊金霍洛旗', null), ('017300', '017000', '乌审旗', null), ('017400', '017000', '杭锦旗', null), ('021000', '021000', '海拉尔区', null), ('021100', '021000', '鄂温克族自治旗', null), ('021200', '021000', '新巴尔虎左旗', null), ('021300', '021000', '新巴尔虎右旗', null), ('021400', '021000', '满洲里市', null), ('021500', '021000', '陈巴尔虎旗', null), ('022150', '021000', '牙克石市', null), ('022250', '021000', '额尔古纳市', null), ('022350', '021000', '根河市', null), ('022450', '021000', '鄂伦春自治旗', null), ('024000', '024000', '元宝山区', null), ('024001', '024000', '松山区', null), ('024002', '024000', '红山区', null), ('024200', '024000', '宁城县', null), ('024300', '024000', '敖汉旗', null), ('024400', '024000', '喀喇沁旗', null), ('024500', '024000', '翁牛特旗', null), ('025150', '024000', '巴林右旗', null), ('025250', '024000', '林西县', null), ('025350', '024000', '克什克腾旗', null), ('025450', '024000', '巴林左旗', null), ('025500', '024000', '阿鲁科尔沁旗', null), ('026000', '026000', '锡林浩特市', null), ('026200', '026000', '西乌珠穆沁旗', null), ('026300', '026000', '东乌珠穆沁旗', null), ('027000', '026000', '太仆寺旗', null), ('027200', '026000', '正蓝旗', null), ('027300', '026000', '多伦县', null), ('028000', '028000', '科尔沁区', null), ('028100', '028000', '科尔沁左翼后旗', null), ('028200', '028000', '库伦旗', null), ('028300', '028000', '奈曼旗', null), ('028400', '028000', '开鲁县', null), ('029100', '028000', '扎鲁特旗', null), ('029200', '028000', '霍林郭勒市', null), ('029300', '028000', '科尔沁左翼中旗', null), ('029400', '137400', '科尔沁右翼中旗', null), ('030000', '030000', '迎泽区', null), ('030006', '030000', '小店区', null), ('030008', '030000', '尖草坪区', null), ('030009', '030000', '杏花岭区', null), ('030021', '030000', '晋源区', null), ('030027', '030000', '万柏林区', null), ('030100', '030000', '阳曲县', null), ('030200', '030000', '古交市', null), ('030300', '030000', '娄烦县', null), ('030400', '030000', '清徐县', null), ('030500', '033000', '交城县', null), ('030600', '030600', '榆次区', null), ('030800', '030600', '太谷县', null), ('030900', '030600', '祁县', null), ('031100', '030600', '平遥县', null), ('031300', '030600', '灵石县', null), ('031400', '041000', '霍州市', null), ('031500', '041000', '汾西县', null), ('031800', '030600', '榆社县', null), ('032000', '030600', '介休市', null), ('032100', '033000', '文水县', null), ('032200', '033000', '汾阳市', null), ('032300', '033000', '孝义市', null), ('032400', '033000', '交口县', null), ('032500', '033000', '石楼县', null), ('032600', '030600', '左权县', null), ('032700', '030600', '和顺县', null), ('033000', '033000', '离石区', null), ('033100', '033000', '方山县', null), ('033200', '033000', '临县', null), ('033300', '033000', '柳林县', null), ('033400', '033000', '中阳县', null), ('034000', '034000', '忻府区', null), ('034100', '034000', '原平市', null), ('034200', '034000', '代县', null), ('034300', '034000', '繁峙县', null), ('034400', '037000', '灵丘县', null), ('035100', '034000', '静乐县', null), ('035200', '033000', '岚县', null), ('035300', '033000', '兴县', null), ('035400', '034000', '定襄县', null), ('035500', '034000', '五台县', null), ('036000', '034000', '宁武县', null), ('036002', '036000', '朔城区', null), ('036100', '034000', '神池县', null), ('036200', '034000', '五寨县', null), ('036300', '034000', '岢岚县', null), ('036400', '034000', '偏关县', null), ('036500', '034000', '河曲县', null), ('036600', '034000', '保德县', null), ('036800', '036000', '平鲁区', null);
INSERT INTO `t_district` VALUES ('036900', '036000', '山阴县', null), ('037000', '037000', '南郊区', null), ('037003', '037000', '新荣区', null), ('037024', '037000', '矿区', null), ('037100', '037000', '左云县', null), ('037200', '036000', '右玉县', null), ('037300', '037000', '大同县', null), ('037400', '037000', '浑源县', null), ('037500', '037000', '广灵县', null), ('037600', '036000', '应县', null), ('038100', '037000', '阳高县', null), ('038200', '037000', '天镇县', null), ('038300', '036000', '怀仁县', null), ('041000', '041000', '尧都区', null), ('041200', '041000', '蒲县', null), ('041300', '041000', '隰县', null), ('041400', '041000', '永和县', null), ('041500', '041000', '襄汾县', null), ('041600', '041000', '洪洞县', null), ('042100', '041000', '乡宁县', null), ('042200', '041000', '吉县', null), ('042300', '041000', '大宁县', null), ('042400', '041000', '古县', null), ('042500', '041000', '安泽县', null), ('042600', '041000', '浮山县', null), ('043000', '041000', '侯马市', null), ('043100', '044000', '新绛县', null), ('043200', '044000', '稷山县', null), ('043300', '044000', '河津市', null), ('043400', '041000', '曲沃县', null), ('043500', '041000', '翼城县', null), ('043600', '044000', '绛县', null), ('043700', '044000', '垣曲县', null), ('043800', '044000', '闻喜县', null), ('044000', '044000', '盐湖区', null), ('044100', '044000', '临猗县', null), ('044200', '044000', '万荣县', null), ('044300', '044000', '平陆县', null), ('044400', '044000', '夏县', null), ('044500', '044000', '永济市', null), ('044600', '044000', '芮城县', null), ('045000', '037000', '城区', null), ('045001', '045000', '城区', null), ('045002', '045000', '矿区', null), ('045008', '045000', '郊区', null), ('045100', '045000', '盂县', null), ('045200', '045000', '平定县', null), ('045300', '030600', '昔阳县', null), ('045400', '030600', '寿阳县', null), ('046000', '048000', '城区', null), ('046010', '046000', '城区', null), ('046021', '046000', '郊区', null), ('046100', '046000', '屯留县', null), ('046200', '046000', '襄垣县', null), ('046300', '046000', '武乡县', null), ('046400', '046000', '沁县', null), ('046500', '046000', '沁源县', null), ('046600', '046000', '长子县', null), ('046700', '048000', '高平市', null), ('047100', '046000', '长治县', null), ('047300', '046000', '壶关县', null), ('047400', '046000', '平顺县', null), ('047500', '046000', '潞城市', null), ('047600', '046000', '黎城县', null), ('048000', '048000', '泽州县', null), ('048100', '048000', '阳城县', null), ('048200', '048000', '沁水县', null), ('048300', '048000', '陵川县', null), ('050000', '075000', '桥东区', null), ('050004', '050000', '新华区', null), ('050006', '050000', '桥西区', null), ('050011', '050000', '长安区', null), ('050030', '050000', '裕华区', null), ('050100', '050000', '井陉矿区', null), ('050200', '050000', '鹿泉市', null), ('050300', '050000', '井陉县', null), ('050400', '050000', '平山县', null), ('050500', '050000', '灵寿县', null), ('050600', '050000', '行唐县', null), ('050700', '050000', '新乐市', null), ('050800', '050000', '正定县', null), ('051130', '050000', '元氏县', null), ('051230', '050000', '赞皇县', null), ('051330', '050000', '高邑县', null), ('051430', '050000', '栾城县', null), ('051530', '050000', '赵县', null), ('051730', '054000', '新河县', null), ('051800', '054000', '南宫市', null), ('052160', '050000', '藁城市', null), ('052200', '050000', '晋州市', null), ('052300', '050000', '辛集市', null), ('052400', '050000', '无极县', null), ('052500', '050000', '深泽县', null), ('052800', '053000', '深州市', null), ('053000', '053000', '桃城区', null), ('053100', '053000', '枣强县', null), ('053200', '053000', '冀州市', null), ('053300', '053000', '武强县', null), ('053400', '053000', '武邑县', null), ('053500', '053000', '景县', null);
INSERT INTO `t_district` VALUES ('053600', '053000', '安平县', null), ('053700', '053000', '阜城县', null), ('053900', '053000', '饶阳县', null), ('054000', '050000', '桥东区', null), ('054001', '054000', '桥东区', null), ('054002', '054000', '桥西区', null), ('054009', '054000', '邢台县', null), ('054106', '054000', '沙河市', null), ('054200', '054000', '内丘县', null), ('054300', '054000', '临城县', null), ('054400', '054000', '南和县', null), ('054500', '054000', '平乡县', null), ('054600', '054000', '广宗县', null), ('054700', '054000', '威县', null), ('054800', '054000', '清河县', null), ('054900', '054000', '临西县', null), ('055150', '054000', '任县', null), ('055250', '054000', '巨鹿县', null), ('055350', '054000', '隆尧县', null), ('055450', '054000', '柏乡县', null), ('055550', '054000', '宁晋县', null), ('056000', '056000', '丛台区', null), ('056006', '056000', '邯山区', null), ('056009', '056000', '复兴区', null), ('056108', '056000', '邯郸县', null), ('056200', '056000', '峰峰矿区', null), ('056300', '056000', '武安市', null), ('056400', '056000', '涉县', null), ('056500', '056000', '磁县', null), ('056600', '056000', '临漳县', null), ('056700', '056000', '成安县', null), ('056800', '056000', '魏县', null), ('056900', '056000', '大名县', null), ('057150', '056000', '永年县', null), ('057250', '056000', '曲周县', null), ('057350', '056000', '鸡泽县', null), ('057450', '056000', '邱县', null), ('057550', '056000', '肥乡县', null), ('057650', '056000', '广平县', null), ('057750', '056000', '馆陶县', null), ('061000', '061000', '新华区', null), ('061014', '061000', '运河区', null), ('061029', '061000', '沧县', null), ('061100', '061000', '黄骅市', null), ('061200', '061000', '海兴县', null), ('061300', '061000', '盐山县', null), ('061400', '061000', '孟村回族自治县', null), ('061500', '061000', '南皮县', null), ('061600', '061000', '东光县', null), ('061800', '061000', '吴桥县', null), ('062150', '061000', '泊头市', null), ('062250', '061000', '献县', null), ('062350', '061000', '肃宁县', null), ('062450', '061000', '河间市', null), ('062550', '061000', '任丘市', null), ('062650', '061000', '青县', null), ('063000', '063000', '丰润区', null), ('063004', '063000', '路南区', null), ('063006', '063000', '路北区', null), ('063020', '063000', '开平区', null), ('063100', '063000', '古冶区', null), ('063200', '063000', '唐海县', null), ('063300', '063000', '丰南区', null), ('063500', '063000', '滦南县', null), ('063600', '063000', '乐亭县', null), ('063700', '063000', '滦县', null), ('064100', '063000', '玉田县', null), ('064200', '063000', '遵化市', null), ('064300', '063000', '迁西县', null), ('064400', '063000', '迁安市', null), ('065000', '065000', '广阳区', null), ('065004', '065000', '安次区', null), ('065200', '065000', '三河市', null), ('065300', '065000', '大厂回族自治县', null), ('065400', '065000', '香河县', null), ('065500', '065000', '固安县', null), ('065600', '065000', '永清县', null), ('065700', '065000', '霸州市', null), ('065800', '065000', '文安县', null), ('065900', '065000', '大城县', null), ('066000', '066000', '海港区', null), ('066007', '066000', '经济技术开发区', null), ('066100', '066000', '北戴河区', null), ('066200', '066000', '山海关区', null), ('066300', '066000', '抚宁县', null), ('066400', '066000', '卢龙县', null), ('066500', '066000', '青龙满族自治县', null), ('066600', '066000', '昌黎县', null), ('067000', '067000', '双桥区', null), ('067101', '067000', '双滦区', null), ('067200', '067000', '鹰手营子矿区', null), ('067300', '067000', '兴隆县', null), ('067400', '067000', '承德县', null), ('067500', '067000', '平泉县', null), ('067600', '067000', '宽城满族自治县', null), ('068150', '067000', '隆化县', null), ('068250', '067000', '滦平县', null), ('068350', '067000', '丰宁满族自治县', null), ('068450', '067000', '围场满族蒙古族自治县', null), ('071000', '071000', '南市区', null);
INSERT INTO `t_district` VALUES ('071023', '071000', '北市区', null), ('071051', '071000', '新市区', null), ('071100', '071000', '清苑县', null), ('071200', '071000', '安国市', null), ('071300', '071000', '博野县', null), ('071400', '071000', '蠡县', null), ('071500', '071000', '高阳县', null), ('071600', '071000', '安新县', null), ('071700', '071000', '容城县', null), ('071800', '071000', '雄县', null), ('072150', '071000', '满城县', null), ('072200', '071000', '顺平县', null), ('072350', '071000', '唐县', null), ('072450', '071000', '望都县', null), ('072550', '071000', '徐水县', null), ('072650', '071000', '定兴县', null), ('072750', '071000', '涿州市', null), ('073000', '071000', '定州市', null), ('073100', '071000', '曲阳县', null), ('073200', '071000', '阜平县', null), ('074000', '071000', '高碑店市', null), ('074100', '071000', '涞水县', null), ('074200', '071000', '易县', null), ('074300', '071000', '涞源县', null), ('075000', '075000', '宣化区', null), ('075002', '075000', '桥西区', null), ('075100', '075000', '宣化县', null), ('075300', '075000', '下花园区', null), ('075400', '075000', '怀来县', null), ('075500', '075000', '赤城县', null), ('075600', '075000', '涿鹿县', null), ('075700', '075000', '蔚县', null), ('075800', '075000', '阳原县', null), ('076150', '075000', '怀安县', null), ('076250', '075000', '万全县', null), ('076350', '075000', '崇礼县', null), ('076450', '075000', '张北县', null), ('076550', '075000', '沽源县', null), ('076650', '075000', '康保县', null), ('076750', '075000', '尚义县', null), ('100000', '100000', '东城区', ''), ('100006', '100000', '朝阳区', null), ('100009', '100000', '西城区', null), ('100022', '100000', '崇文区', null), ('100036', '100000', '海淀区', null), ('100037', '100000', '丰台区', null), ('100040', '100000', '石景山区', null), ('100050', '100000', '宣武区', null), ('101100', '100000', '通州区', null), ('101200', '100000', '平谷区', null), ('101300', '100000', '顺义区', null), ('101400', '100000', '怀柔区', null), ('101500', '100000', '密云县', null), ('102100', '100000', '延庆县', null), ('102200', '100000', '昌平区', null), ('102300', '100000', '门头沟区', null), ('102400', '100000', '房山区', null), ('102600', '100000', '大兴区', null), ('110000', '110000', '东陵区', null), ('110003', '110000', '于洪区', null), ('110004', '110000', '和平区', null), ('110005', '110000', '大东区', null), ('110010', '110000', '皇姑区', null), ('110100', '110000', '沈北新区', null), ('110101', '110000', '苏家屯区', null), ('110200', '110000', '辽中县', null), ('110300', '113000', '新抚区', null), ('110400', '110000', '法库县', null), ('110500', '110000', '康平县', null), ('110800', '110000', '沈河区', null), ('111000', '111000', '太子河区', null), ('111001', '111000', '宏伟区', null), ('111002', '111000', '弓长岭区', null), ('111003', '111000', '文圣区', null), ('111010', '111000', '白塔区', null), ('111200', '111000', '辽阳县', null), ('111300', '111000', '灯塔市', null), ('112000', '112000', '清河区', null), ('112010', '112000', '银州区', null), ('112300', '112000', '开原市', null), ('112400', '112000', '西丰县', null), ('112500', '112000', '昌图县', null), ('112600', '112000', '铁岭县', null), ('112700', '112000', '调兵山市', null), ('113000', '113000', '东洲区', null), ('113001', '113000', '望花区', null), ('113002', '113000', '顺城区', null), ('113100', '113000', '抚顺县', null), ('113200', '113000', '新宾满族自治县', null), ('113300', '113000', '清原满族自治县', null), ('114000', '110000', '铁西区', null), ('114001', '114000', '千山区', null), ('114010', '114000', '立山区', null), ('114013', '114000', '铁西区', null), ('114030', '114000', '铁东区', null), ('114100', '114000', '台安县', null), ('114200', '114000', '海城市', null), ('114300', '114000', '岫岩满族自治县', null), ('115000', '115000', '站前区', null), ('115001', '115000', '老边区', null);
INSERT INTO `t_district` VALUES ('115002', '115000', '西市区', null), ('115007', '115000', '鲅鱼圈区', null), ('115100', '115000', '大石桥市', null), ('115200', '115000', '盖州市', null), ('116000', '116000', '中山区', null), ('116001', '116000', '西岗区', null), ('116010', '116000', '旅顺口区', null), ('116020', '116000', '金州区', null), ('116060', '116000', '沙河口区', null), ('116200', '116000', '普兰店市', null), ('116300', '116000', '瓦房店市', null), ('116400', '116000', '庄河市', null), ('116500', '116000', '长海县', null), ('116800', '116000', '甘井子区', null), ('117000', '117000', '南芬区', null), ('117001', '117000', '平山区', null), ('117002', '117000', '明山区', null), ('117009', '117000', '溪湖区', null), ('117100', '117000', '本溪满族自治县', null), ('117200', '117000', '桓仁满族自治县', null), ('118000', '118000', '元宝区', null), ('118010', '118000', '振兴区', null), ('118020', '118000', '振安区', null), ('118100', '118000', '凤城市', null), ('118200', '118000', '宽甸满族自治县', null), ('118300', '118000', '东港市', null), ('121000', '121000', '凌河区', null), ('121009', '121000', '古塔区', null), ('121080', '121000', '太和区', null), ('121100', '121000', '义县', null), ('121200', '121000', '凌海市', null), ('121300', '122000', '北票市', null), ('121301', '121000', '北镇市', null), ('121400', '121000', '黑山县', null), ('122000', '122000', '双塔区', null), ('122001', '122000', '朝阳县', null), ('122002', '122000', '龙城区', null), ('122300', '122000', '喀喇沁左翼蒙古族自治县', null), ('122400', '122000', '建平县', null), ('122500', '122000', '凌源市', null), ('123000', '110000', '新民市', null), ('123001', '123000', '太平区', null), ('123010', '123000', '海州区', null), ('123020', '123000', '清河门区', null), ('123030', '123000', '细河区', null), ('123100', '123000', '阜新蒙古族自治县', null), ('123200', '123000', '彰武县', null), ('124000', '124000', '兴隆台区', null), ('124001', '124000', '双台子区', null), ('124100', '124000', '盘山县', null), ('124200', '124000', '大洼县', null), ('125000', '125000', '南票区', null), ('125001', '125000', '连山区', null), ('125002', '125000', '龙港区', null), ('125100', '125000', '兴城市', null), ('125101', '123000', '新邱区', null), ('125200', '125000', '绥中县', null), ('125300', '125000', '建昌县', null), ('130000', '130000', '二道区', null), ('130001', '130000', '南关区', null), ('130002', '130000', '宽城区', null), ('130003', '130000', '朝阳区', null), ('130004', '130000', '绿园区', null), ('130200', '130000', '农安县', null), ('130300', '130000', '德惠市', null), ('130400', '130000', '榆树市', null), ('130500', '130000', '九台市', null), ('130600', '130000', '双阳区', null), ('131100', '138000', '前郭尔罗斯蒙古族自治县', null), ('131200', '138000', '扶余县', null), ('131300', '137000', '大安市', null), ('131400', '138000', '乾安县', null), ('131500', '138000', '长岭县', null), ('132000', '132000', '丰满区', null), ('132001', '132000', '昌邑区', null), ('132002', '132000', '船营区', null), ('132003', '132000', '龙潭区', null), ('132100', '132000', '永吉县', null), ('132300', '132000', '磐石市', null), ('132400', '132000', '桦甸市', null), ('132500', '132000', '蛟河市', null), ('132600', '132000', '舒兰市', null), ('133000', '136000', '伊通满族自治县', null), ('133100', '133000', '汪清县', null), ('133200', '136200', '西安区', null), ('133300', '133000', '珲春市', null), ('133400', '133000', '龙井市', null), ('133500', '133000', '和龙市', null), ('133600', '133000', '安图县', null), ('133700', '133000', '敦化市', null), ('134000', '134000', '东昌区', null), ('134001', '134000', '二道江区', null), ('134002', '134000', '通化县', null), ('134100', '137000', '通榆县', null), ('134200', '134000', '集安市', null), ('134300', '134300', '八道江区', null), ('134400', '134300', '长白朝鲜族自治县', null), ('134500', '134300', '抚松县', null), ('134600', '134300', '临江市', null), ('134700', '134300', '江源区', null);
INSERT INTO `t_district` VALUES ('135000', '134000', '梅河口市', null), ('135100', '134000', '辉南县', null), ('135200', '134300', '靖宇县', null), ('135300', '134000', '柳河县', null), ('136000', '136000', '铁东区', null), ('136001', '136000', '铁西区', null), ('136100', '136000', '公主岭市', null), ('136200', '133000', '延吉市', null), ('136201', '136200', '龙山区', null), ('136300', '136200', '东丰县', null), ('136400', '136000', '双辽市', null), ('136500', '136000', '梨树县', null), ('136600', '136200', '东辽县', null), ('137000', '137000', '洮北区', null), ('137100', '137000', '洮南市', null), ('137200', '133000', '图们市', null), ('137300', '137000', '镇赉县', null), ('137400', '137400', '乌兰浩特市', null), ('137500', '137400', '突泉县', null), ('137600', '137400', '扎赉特旗', null), ('137702', '137400', '科尔沁右翼前旗', null), ('137803', '137400', '阿尔山市', null), ('138000', '138000', '宁江区', null), ('150000', '150000', '南岗区', null), ('150001', '150000', '平房区', null), ('150002', '150000', '松北区', null), ('150004', '150000', '道外区', null), ('150005', '150000', '道里区', null), ('150008', '150000', '香坊区', null), ('150100', '150000', '双城市', null), ('150200', '150000', '五常市', null), ('150300', '150000', '阿城区', null), ('150400', '150000', '宾县', null), ('150500', '150000', '呼兰区', null), ('150600', '150000', '尚志市', null), ('150800', '150000', '方正县', null), ('150900', '150000', '通河县', null), ('151100', '152000', '肇东市', null), ('151400', '152000', '安达市', null), ('151500', '152000', '兰西县', null), ('151600', '152000', '青冈县', null), ('151700', '152000', '明水县', null), ('151800', '150000', '巴彦县', null), ('151900', '150000', '木兰县', null), ('152000', '152000', '北林区', null), ('152100', '152000', '望奎县', null), ('152200', '152000', '绥棱县', null), ('152300', '152000', '海伦市', null), ('152400', '152000', '庆安县', null), ('152500', '153000', '铁力市', null), ('153000', '153000', '上甘岭区', null), ('153001', '153000', '乌伊岭区', null), ('153002', '153000', '乌马河区', null), ('153003', '153000', '五营区', null), ('153004', '153000', '伊春区', null), ('153005', '153000', '南岔区', null), ('153006', '153000', '友好区', null), ('153007', '153000', '带岭区', null), ('153010', '153000', '汤旺河区', null), ('153020', '153000', '红星区', null), ('153030', '153000', '美溪区', null), ('153036', '153000', '新青区', null), ('153040', '153000', '翠峦区', null), ('153050', '153000', '西林区', null), ('153060', '153000', '金山屯区', null), ('153200', '153000', '嘉荫县', null), ('154000', '154000', '东风区', null), ('154001', '154000', '前进区', null), ('154002', '154000', '向阳区', null), ('154024', '154000', '郊区', null), ('154100', '154600', '新兴区', null), ('154101', '154100', '兴安区', null), ('154102', '154100', '向阳区', null), ('154103', '154100', '工农区', null), ('154105', '154100', '兴山区', null), ('154110', '154100', '东山区', null), ('154122', '154100', '南山区', null), ('154200', '154100', '萝北县', null), ('154300', '158100', '虎林市', null), ('154400', '154000', '桦川县', null), ('154500', '154600', '勃利县', null), ('154600', '154600', '桃山区', null), ('154601', '154600', '茄子河区', null), ('154700', '154000', '汤原县', null), ('154800', '150000', '依兰县', null), ('155100', '155100', '尖山区', null), ('155101', '155100', '四方台区', null), ('155102', '155100', '宝山区', null), ('155110', '155100', '岭东区', null), ('155600', '155100', '宝清县', null), ('155700', '155100', '饶河县', null), ('155800', '155100', '友谊县', null), ('155900', '155100', '集贤县', null), ('156100', '154000', '富锦市', null), ('156200', '154100', '绥滨县', null), ('156400', '154000', '同江市', null), ('156500', '154000', '抚远县', null), ('157000', '150000', '延寿县', null), ('157001', '157000', '爱民区', null), ('157002', '157000', '西安区', null);
INSERT INTO `t_district` VALUES ('157005', '157000', '东安区', null), ('157014', '157000', '阳明区', null), ('157100', '157000', '海林市', null), ('157200', '157000', '东宁县', null), ('157300', '157000', '绥芬河市', null), ('157400', '157000', '宁安市', null), ('157500', '157000', '穆棱市', null), ('157600', '157000', '林口县', null), ('158100', '158100', '城子河区', null), ('158101', '158100', '恒山区', null), ('158102', '158100', '梨树区', null), ('158103', '158100', '滴道区', null), ('158106', '158100', '鸡东县', null), ('158107', '158100', '鸡冠区', null), ('158108', '158100', '麻山区', null), ('158200', '154000', '桦南县', null), ('158300', '158100', '密山市', null), ('161000', '161000', '富拉尔基区', null), ('161001', '161000', '昂昂溪区', null), ('161002', '161000', '梅里斯达斡尔族区', null), ('161003', '161000', '碾子山区', null), ('161004', '161000', '铁锋区', null), ('161006', '161000', '建华区', null), ('161007', '161000', '龙沙区', null), ('161100', '161000', '龙江县', null), ('161200', '161000', '富裕县', null), ('161300', '161000', '讷河市', null), ('161400', '164300', '嫩江县', null), ('161500', '161000', '依安县', null), ('161600', '161000', '克山县', null), ('162100', '161000', '甘南县', null), ('162400', '161000', '泰来县', null), ('162650', '021000', '扎兰屯市', null), ('162750', '021000', '阿荣旗', null), ('162850', '021000', '莫力达瓦达斡尔族自治旗', null), ('163000', '163000', '大同区', null), ('163001', '163000', '红岗区', null), ('163002', '163000', '萨尔图区', null), ('163003', '163000', '让胡路区', null), ('163004', '163000', '龙凤区', null), ('164000', '164300', '北安市', null), ('164100', '164300', '五大连池市', null), ('164200', '164300', '孙吴县', null), ('164300', '164300', '爱辉区', null), ('164412', '164300', '逊克县', null), ('164700', '161000', '拜泉县', null), ('164800', '161000', '克东县', null), ('165000', '165000', '加格达奇区', null), ('165002', '165000', '松岭区', null), ('165023', '165000', '新林区', null), ('165036', '165000', '呼中区', null), ('165100', '165000', '呼玛县', null), ('165200', '165000', '塔河县', null), ('165300', '165000', '漠河县', null), ('166200', '163000', '杜尔伯特蒙古族自治县', null), ('166300', '163000', '林甸县', null), ('166400', '163000', '肇州县', null), ('166500', '163000', '肇源县', null), ('200000', '200000', '徐汇区', null), ('200010', '200000', '黄浦区', null), ('200020', '200000', '卢湾区', null), ('200040', '200000', '静安区', null), ('200050', '200000', '长宁区', null), ('200061', '200000', '普陀区', null), ('200070', '200000', '闸北区', null), ('200081', '200000', '虹口区', null), ('200090', '200000', '杨浦区', null), ('200120', '200000', '浦东新区', null), ('201100', '200000', '闵行区', null), ('201300', '200000', '南汇区', null), ('201400', '200000', '奉贤区', null), ('201500', '200000', '金山区', null), ('201600', '200000', '松江区', null), ('201700', '200000', '青浦区', null), ('201800', '200000', '嘉定区', null), ('201900', '200000', '宝山区', null), ('202150', '200000', '崇明县', null), ('202450', '316000', '嵊泗县', null), ('210000', '210000', '下关区', null), ('210001', '210000', '建邺区', null), ('210002', '210000', '栖霞区', null), ('210003', '210000', '浦口区', null), ('210004', '210000', '玄武区', null), ('210005', '210000', '白下区', null), ('210006', '210000', '秦淮区', null), ('210007', '210000', '雨花台区', null), ('210008', '210000', '鼓楼区', null), ('211100', '210000', '江宁区', null), ('211200', '210000', '溧水县', null), ('211300', '210000', '高淳县', null), ('211400', '225000', '仪征市', null), ('211500', '210000', '六合区', null), ('211600', '223001', '金湖县', null), ('211700', '223001', '盱眙县', null), ('212001', '212000', '京口区', null), ('212002', '212000', '润州区', null), ('212100', '212000', '丹徒区', null), ('212200', '212000', '扬中市', null), ('212300', '212000', '丹阳市', null), ('212400', '212000', '句容市', null);
INSERT INTO `t_district` VALUES ('213000', '213000', '天宁区', null), ('213001', '213000', '戚墅堰区', null), ('213002', '213000', '新北区', null), ('213004', '213000', '钟楼区', null), ('213100', '213000', '武进区', null), ('213200', '213000', '金坛市', null), ('213300', '213000', '溧阳市', null), ('214000', '214000', '北塘区', null), ('214001', '214000', '南长区', null), ('214002', '214000', '崇安区', null), ('214003', '214000', '惠山区', null), ('214004', '214000', '锡山区', null), ('214026', '214000', '滨湖区', null), ('214200', '214000', '宜兴市', null), ('214400', '214000', '江阴市', null), ('214500', '215300', '靖江市', null), ('215000', '215000', '平江区', null), ('215001', '215000', '沧浪区', null), ('215002', '215000', '金阊区', null), ('215003', '215000', '虎丘区', null), ('215100', '215000', '吴中区', null), ('215101', '215000', '相城区', null), ('215200', '215000', '吴江市', null), ('215316', '215000', '昆山市', null), ('215400', '215000', '太仓市', null), ('215500', '215000', '常熟市', null), ('215600', '215000', '张家港市', null), ('221000', '221000', '九里区', null), ('221001', '221000', '云龙区', null), ('221002', '221000', '泉山区', null), ('221003', '221000', '贾汪区', null), ('221004', '221000', '鼓楼区', null), ('221100', '221000', '铜山县', null), ('221200', '221000', '睢宁县', null), ('221300', '221000', '邳州市', null), ('221400', '221000', '新沂市', null), ('221600', '221000', '沛县', null), ('221700', '221000', '丰县', null), ('222000', '222000', '新浦区', null), ('222001', '222000', '海州区', null), ('222002', '222000', '连云区', null), ('222100', '222000', '赣榆县', null), ('222200', '222000', '灌云县', null), ('222300', '222000', '东海县', null), ('223001', '223001', '清河区', null), ('223002', '223001', '清浦区', null), ('223100', '223001', '洪泽县', null), ('223200', '223001', '楚州区', null), ('223300', '223001', '淮阴区', null), ('223400', '223001', '涟水县', null), ('223500', '222000', '灌南县', null), ('223600', '223800', '沭阳县', null), ('223700', '223800', '泗阳县', null), ('223800', '223800', '宿城区', null), ('223801', '223800', '宿豫区', null), ('223900', '223800', '泗洪县', null), ('224000', '224000', '滨海县', null), ('224001', '224000', '亭湖区', null), ('224011', '224000', '盐都区', null), ('224100', '224000', '大丰市', null), ('224200', '224000', '东台市', null), ('224300', '224000', '射阳县', null), ('224400', '224000', '阜宁县', null), ('224600', '224000', '响水县', null), ('224700', '224000', '建湖县', null), ('225000', '225000', '广陵区', null), ('225002', '225000', '维扬区', null), ('225100', '225000', '邗江区', null), ('225200', '225000', '江都市', null), ('225300', '215300', '海陵区', null), ('225301', '215300', '高港区', null), ('225400', '215300', '泰兴市', null), ('225500', '215300', '姜堰市', null), ('225600', '225000', '高邮市', null), ('225700', '215300', '兴化市', null), ('225800', '225000', '宝应县', null), ('226000', '226000', '崇川区', null), ('226001', '226000', '港闸区', null), ('226100', '226000', '海门市', null), ('226200', '226000', '启东市', null), ('226300', '226000', '通州市', null), ('226400', '226000', '如东县', null), ('226500', '226000', '如皋市', null), ('226600', '226000', '海安县', null), ('230000', '230000', '蜀山区', null), ('230001', '230000', '包河区', null), ('230002', '230000', '庐阳区', null), ('230003', '230000', '瑶海区', null), ('230004', '230000', '肥东县', null), ('231100', '230000', '长丰县', null), ('231200', '230000', '肥西县', null), ('231300', '237000', '舒城县', null), ('231400', '246000', '桐城市', null), ('231500', '238000', '庐江县', null), ('232000', '232000', '八公山区', null), ('232001', '232000', '大通区', null), ('232002', '232000', '潘集区', null), ('232003', '232000', '田家庵区', null), ('232004', '232000', '谢家集区', null), ('232100', '232000', '凤台县', null);
INSERT INTO `t_district` VALUES ('232200', '237000', '寿县', null), ('233001', '233000', '淮上区', null), ('233002', '233000', '禹会区', null), ('233003', '233000', '蚌山区', null), ('233004', '233000', '龙子湖区', null), ('233100', '239000', '凤阳县', null), ('233200', '239000', '定远县', null), ('233300', '233000', '五河县', null), ('233400', '233000', '怀远县', null), ('233500', '236800', '蒙城县', null), ('233600', '236800', '涡阳县', null), ('233700', '233000', '固镇县', null), ('234000', '234000', '墉桥区', null), ('234200', '234000', '灵璧县', null), ('234300', '234000', '泗县', null), ('235001', '235000', '杜集区', null), ('235002', '235000', '烈山区', null), ('235003', '235000', '相山区', null), ('235100', '235000', '濉溪县', null), ('235200', '234000', '萧县', null), ('235300', '234000', '砀山县', null), ('236001', '236000', '颍东区', null), ('236002', '236000', '颍州区', null), ('236003', '236000', '颍泉区', null), ('236200', '236000', '颍上县', null), ('236300', '236000', '阜南县', null), ('236400', '236000', '临泉县', null), ('236500', '236000', '界首市', null), ('236600', '236000', '太和县', null), ('236700', '236800', '利辛县', null), ('236800', '236800', '谯城区', null), ('237000', '237000', '裕安区', null), ('237001', '237000', '金安区', null), ('237200', '237000', '霍山县', null), ('237300', '237000', '金寨县', null), ('237400', '237000', '霍邱县', null), ('238000', '238000', '居巢区', null), ('238100', '238000', '含山县', null), ('238200', '238000', '和县', null), ('238300', '238000', '无为县', null), ('239000', '239000', '琅琊区', null), ('239001', '239000', '南谯区', null), ('239200', '239000', '来安县', null), ('239300', '239000', '天长市', null), ('239400', '239000', '明光市', null), ('239500', '239000', '全椒县', null), ('241001', '241000', '三山区', null), ('241002', '241000', '弋江区', null), ('241003', '241000', '镜湖区', null), ('241004', '241000', '鸠江区', null), ('241100', '241000', '芜湖县', null), ('241200', '241000', '繁昌县', null), ('242000', '242000', '宣州区', null), ('242100', '242000', '郎溪县', null), ('242200', '242000', '广德县', null), ('242300', '242000', '宁国市', null), ('242400', '241000', '南陵县', null), ('242500', '242000', '泾县', null), ('242600', '242000', '旌德县', null), ('242800', '247100', '青阳县', null), ('243001', '243000', '花山区', null), ('243002', '243000', '金家庄区', null), ('243003', '243000', '雨山区', null), ('243100', '243000', '当涂县', null), ('244000', '244000', '狮子山区', null), ('244001', '244000', '铜官山区', null), ('244011', '244000', '郊区', null), ('244100', '244000', '铜陵县', null), ('245000', '245000', '屯溪区', null), ('245001', '245000', '黄山区', null), ('245061', '245000', '徽州区', null), ('245100', '247100', '石台县', null), ('245200', '245000', '歙县', null), ('245300', '242000', '绩溪县', null), ('245400', '245000', '休宁县', null), ('245500', '245000', '黟县', null), ('245600', '245000', '祁门县', null), ('246000', '246000', '大观区', null), ('246001', '246000', '宜秀区', null), ('246002', '246000', '迎江区', null), ('246100', '246000', '怀宁县', null), ('246200', '246000', '望江县', null), ('246300', '246000', '潜山县', null), ('246400', '246000', '太湖县', null), ('246500', '246000', '宿松县', null), ('246600', '246000', '岳西县', null), ('246700', '246000', '枞阳县', null), ('247100', '247100', '贵池区', null), ('247200', '247100', '东至县', null), ('250000', '250000', '历下区', null), ('250001', '250000', '市中区', null), ('250032', '250000', '天桥区', null), ('250100', '250000', '历城区', null), ('250118', '250000', '槐荫区', null), ('250200', '250000', '章丘市', null), ('250300', '250000', '长清区', null), ('250400', '250000', '平阴县', null), ('251100', '253000', '齐河县', null), ('251200', '253000', '禹城市', null), ('251400', '250000', '济阳县', null);
INSERT INTO `t_district` VALUES ('251500', '253000', '临邑县', null), ('251600', '250000', '商河县', null), ('251700', '256600', '惠民县', null), ('251800', '256600', '阳信县', null), ('251900', '256600', '无棣县', null), ('252000', '252000', '东昌府区', null), ('252100', '252000', '茌平县', null), ('252200', '252000', '东阿县', null), ('252300', '252000', '阳谷县', null), ('252400', '252000', '莘县', null), ('252500', '252000', '冠县', null), ('252600', '252000', '临清市', null), ('252800', '252000', '高唐县', null), ('253000', '253000', '德城区', null), ('253100', '253000', '平原县', null), ('253200', '253000', '夏津县', null), ('253300', '253000', '武城县', null), ('253400', '253000', '宁津县', null), ('253500', '253000', '陵县', null), ('253600', '253000', '乐陵市', null), ('253700', '253000', '庆云县', null), ('253800', '053000', '故城县', null), ('255000', '255000', '张店区', null), ('255100', '255000', '淄川区', null), ('255200', '255000', '博山区', null), ('255300', '255000', '周村区', null), ('255400', '255000', '临淄区', null), ('256100', '255000', '沂源县', null), ('256200', '256600', '邹平县', null), ('256300', '255000', '高青县', null), ('256400', '255000', '桓台县', null), ('256500', '256600', '博兴县', null), ('256600', '256600', '滨城区', null), ('256800', '256600', '沾化县', null), ('257100', '257000', '东营区', null), ('257200', '257000', '河口区', null), ('257300', '257000', '广饶县', null), ('257400', '257000', '利津县', null), ('257500', '257000', '垦利县', null), ('261000', '261000', '奎文区', null), ('261001', '261000', '潍城区', null), ('261100', '261000', '寒亭区', null), ('261200', '261000', '坊子区', null), ('261300', '261000', '昌邑市', null), ('261400', '264000', '莱州市', null), ('261500', '261000', '高密市', null), ('262100', '261000', '安丘市', null), ('262200', '261000', '诸城市', null), ('262300', '276800', '五莲县', null), ('262400', '261000', '昌乐县', null), ('262500', '261000', '青州市', null), ('262600', '261000', '临朐县', null), ('262700', '261000', '寿光市', null), ('264000', '264000', '开发区', null), ('264001', '264000', '芝罘区', null), ('264002', '264000', '莱山区', null), ('264100', '264000', '牟平区', null), ('264200', '264200', '环翠区', null), ('264300', '264200', '荣成市', null), ('264400', '264200', '文登市', null), ('264500', '264200', '乳山市', null), ('265100', '264000', '海阳市', null), ('265300', '264000', '栖霞市', null), ('265400', '264000', '招远市', null), ('265500', '264000', '福山区', null), ('265600', '264000', '蓬莱市', null), ('265700', '264000', '龙口市', null), ('265800', '264000', '长岛县', null), ('266000', '266000', '黄岛区', null), ('266001', '266000', '四方区', null), ('266002', '266000', '城阳区', null), ('266005', '266000', '市北区', null), ('266006', '266000', '市南区', null), ('266010', '266000', '李沧区', null), ('266100', '266000', '崂山区', null), ('266200', '266000', '即墨市', null), ('266300', '266000', '胶州市', null), ('266400', '266000', '胶南市', null), ('266600', '264000', '莱阳市', null), ('266601', '266000', '莱西市', null), ('266700', '266000', '平度市', null), ('271000', '271000', '岱岳区', null), ('271001', '271000', '泰山区', null), ('271100', '271100', '莱城区', null), ('271103', '271100', '钢城区', null), ('271200', '271000', '新泰市', null), ('271400', '271000', '宁阳县', null), ('271500', '271000', '东平县', null), ('271600', '271000', '肥城市', null), ('272000', '272000', '任城区', null), ('272001', '272000', '兖州市', null), ('272002', '272000', '市中区', null), ('272200', '272000', '金乡县', null), ('272300', '272000', '鱼台县', null), ('272400', '272000', '嘉祥县', null), ('272500', '272000', '汶上县', null), ('272600', '272000', '梁山县', null), ('273100', '272000', '曲阜市', null), ('273200', '272000', '泗水县', null), ('273300', '276000', '平邑县', null);
INSERT INTO `t_district` VALUES ('273400', '276000', '费县', null), ('273500', '272000', '邹城市', null), ('274000', '274000', '牡丹区', null), ('274100', '274000', '定陶县', null), ('274200', '274000', '成武县', null), ('274300', '274000', '单县', null), ('274400', '274000', '曹县', null), ('274500', '274000', '东明县', null), ('274600', '274000', '鄄城县', null), ('274700', '274000', '郓城县', null), ('274900', '274000', '巨野县', null), ('276000', '276000', '兰山区', null), ('276001', '276000', '河东区', null), ('276002', '276000', '罗庄区', null), ('276100', '276000', '郯城县', null), ('276200', '276000', '蒙阴县', null), ('276300', '276000', '沂南县', null), ('276400', '276000', '沂水县', null), ('276500', '276800', '莒县', null), ('276600', '276000', '莒南县', null), ('276700', '276000', '临沭县', null), ('276800', '276800', '东港区', null), ('276801', '276800', '岚山区', null), ('277000', '277000', '薛城区', null), ('277101', '277000', '市中区', null), ('277200', '277000', '山亭区', null), ('277300', '277000', '峄城区', null), ('277400', '277000', '台儿庄区', null), ('277500', '277000', '滕州市', null), ('277600', '272000', '微山县', null), ('277700', '276000', '苍山县', null), ('300010', '300000', '河东区', null), ('300020', '300000', '和平区', null), ('300060', '300000', '河西区', null), ('300071', '300000', '南开区', null), ('300090', '300000', '河北区', null), ('300111', '300000', '西青区', null), ('300121', '300000', '红桥区', null), ('300134', '300000', '北辰区', null), ('300161', '300000', '东丽区', null), ('300222', '300000', '津南区', null), ('300270', '300000', '大港区', null), ('300450', '300000', '塘沽区', null), ('300480', '300000', '汉沽区', null), ('301500', '300000', '宁河县', null), ('301600', '300000', '静海县', null), ('301700', '300000', '武清区', null), ('301800', '300000', '宝坻区', null), ('301900', '300000', '蓟县', null), ('310000', '310000', '上城区', null), ('310001', '310000', '下城区', null), ('310002', '310000', '拱墅区', null), ('310003', '310000', '江干区', null), ('310004', '310000', '滨江区', null), ('310005', '310000', '西湖区', null), ('311100', '310000', '余杭区', null), ('311200', '310000', '萧山区', null), ('311300', '310000', '临安市', null), ('311400', '310000', '富阳市', null), ('311500', '310000', '桐庐县', null), ('311600', '310000', '建德市', null), ('311700', '310000', '淳安县', null), ('311800', '312000', '诸暨市', null), ('312000', '312000', '绍兴县', null), ('312002', '312000', '越城区', null), ('312300', '312000', '上虞市', null), ('312400', '312000', '嵊州市', null), ('312500', '312000', '新昌县', null), ('313000', '313000', '南浔区', null), ('313001', '313000', '吴兴区', null), ('313100', '313000', '长兴县', null), ('313200', '313000', '德清县', null), ('313300', '313000', '安吉县', null), ('314000', '314000', '南湖区', null), ('314011', '314000', '秀洲区', null), ('314100', '314000', '嘉善县', null), ('314200', '314000', '平湖市', null), ('314300', '314000', '海盐县', null), ('314400', '314000', '海宁市', null), ('314500', '314000', '桐乡市', null), ('315000', '315000', '江东区', null), ('315001', '315000', '江北区', null), ('315002', '315000', '海曙区', null), ('315100', '315000', '鄞州区', null), ('315200', '315000', '镇海区', null), ('315300', '315000', '慈溪市', null), ('315400', '315000', '余姚市', null), ('315500', '315000', '奉化市', null), ('315600', '315000', '宁海县', null), ('315700', '315000', '象山县', null), ('315800', '315000', '北仑区', null), ('316000', '316000', '定海区', null), ('316100', '316000', '普陀区', null), ('316200', '316000', '岱山县', null), ('317000', '318000', '临海市', null), ('317100', '318000', '三门县', null), ('317200', '318000', '天台县', null), ('317300', '318000', '仙居县', null), ('317500', '318000', '温岭市', null), ('317600', '318000', '玉环县', null);
INSERT INTO `t_district` VALUES ('317700', '318000', '椒江区', null), ('318000', '318000', '路桥区', null), ('318020', '318000', '黄岩区', null), ('321000', '321000', '金东区', null), ('321001', '321000', '婺城区', null), ('321100', '321000', '兰溪市', null), ('321200', '321000', '武义县', null), ('321300', '321000', '永康市', null), ('321400', '323000', '缙云县', null), ('322000', '321000', '义乌市', null), ('322100', '321000', '东阳市', null), ('322200', '321000', '浦江县', null), ('322300', '321000', '磐安县', null), ('323000', '323000', '莲都区', null), ('323300', '323000', '遂昌县', null), ('323400', '323000', '松阳县', null), ('323500', '323000', '景宁畲族自治县', null), ('323600', '323000', '云和县', null), ('323700', '323000', '龙泉市', null), ('323800', '323000', '庆元县', null), ('323900', '323000', '青田县', null), ('324001', '324000', '柯城区', null), ('324002', '324000', '衢江区', null), ('324100', '324000', '江山市', null), ('324200', '324000', '常山县', null), ('324300', '324000', '开化县', null), ('324400', '324000', '龙游县', null), ('325001', '325000', '瓯海区', null), ('325002', '325000', '鹿城区', null), ('325003', '325000', '龙湾区', null), ('325100', '325000', '永嘉县', null), ('325200', '325000', '瑞安市', null), ('325300', '325000', '文成县', null), ('325400', '325000', '平阳县', null), ('325500', '325000', '泰顺县', null), ('325600', '325000', '乐清市', null), ('325700', '325000', '洞头县', null), ('325800', '325000', '苍南县', null), ('330000', '330000', '东湖区', null), ('330001', '330000', '青山湖区', null), ('330002', '330000', '西湖区', null), ('330003', '330000', '青云谱区', null), ('330010', '330000', '湾里区', null), ('330100', '330000', '新建县', null), ('330200', '330000', '南昌县', null), ('330300', '332000', '永修县', null), ('330400', '332000', '德安县', null), ('330500', '330000', '安义县', null), ('330600', '336000', '靖安县', null), ('330700', '336000', '奉新县', null), ('330800', '336000', '高安市', null), ('331100', '336000', '丰城市', null), ('331200', '336000', '樟树市', null), ('331300', '343000', '新干县', null), ('331400', '343000', '峡江县', null), ('331500', '343000', '永丰县', null), ('331600', '343000', '吉水县', null), ('331700', '330000', '进贤县', null), ('331800', '344000', '东乡县', null), ('332000', '332000', '共青城', null), ('332001', '332000', '浔阳区', null), ('332100', '332000', '九江县', null), ('332200', '332000', '瑞昌市', null), ('332300', '332000', '武宁县', null), ('332400', '332000', '修水县', null), ('332500', '332000', '湖口县', null), ('332600', '332000', '都昌县', null), ('332700', '332000', '彭泽县', null), ('332800', '332000', '星子县', null), ('332900', '332000', '庐山区', null), ('333000', '333000', '昌江区', null), ('333002', '333000', '珠山区', null), ('333100', '334000', '鄱阳县', null), ('333200', '334000', '婺源县', null), ('333300', '333000', '乐平市', null), ('333400', '333000', '浮梁县', null), ('334000', '334000', '信州区', null), ('334100', '334000', '上饶县', null), ('334200', '334000', '德兴市', null), ('334300', '334000', '横峰县', null), ('334400', '334000', '弋阳县', null), ('334500', '334000', '铅山县', null), ('334600', '334000', '广丰县', null), ('334700', '334000', '玉山县', null), ('335000', '335000', '月湖区', null), ('335100', '334000', '余干县', null), ('335200', '335000', '余江县', null), ('335300', '344000', '资溪县', null), ('335400', '335000', '贵溪市', null), ('335500', '334000', '万年县', null), ('336000', '336000', '袁州区', null), ('336100', '336000', '万载县', null), ('336200', '336000', '铜鼓县', null), ('336300', '336000', '宜丰县', null), ('336400', '336000', '上高县', null), ('336600', '338000', '分宜县', null), ('337000', '337000', '上栗县', null), ('337001', '337000', '安源区', null), ('337002', '337000', '湘东区', null), ('337003', '337000', '芦溪县', null);
INSERT INTO `t_district` VALUES ('337100', '337000', '莲花县', null), ('338000', '338000', '渝水区', null), ('341000', '341000', '章贡区', null), ('341100', '341000', '赣县', null), ('341200', '341000', '上犹县', null), ('341300', '341000', '崇义县', null), ('341400', '341000', '南康市', null), ('341500', '341000', '大余县', null), ('341600', '341000', '信丰县', null), ('341700', '341000', '龙南县', null), ('341800', '341000', '全南县', null), ('341900', '341000', '定南县', null), ('342100', '341000', '安远县', null), ('342200', '341000', '寻乌县', null), ('342300', '341000', '于都县', null), ('342400', '341000', '兴国县', null), ('342500', '341000', '瑞金市', null), ('342600', '341000', '会昌县', null), ('342700', '341000', '石城县', null), ('342800', '341000', '宁都县', null), ('343000', '343000', '吉州区', null), ('343001', '343000', '青原区', null), ('343100', '343000', '吉安县', null), ('343200', '343000', '安福县', null), ('343400', '343000', '永新县', null), ('343600', '343000', '井冈山市', null), ('343700', '343000', '泰和县', null), ('343800', '343000', '万安县', null), ('343900', '343000', '遂川县', null), ('344100', '344000', '临川区', null), ('344200', '344000', '崇仁县', null), ('344300', '344000', '乐安县', null), ('344400', '344000', '宜黄县', null), ('344500', '344000', '南丰县', null), ('344600', '344000', '黎川县', null), ('344700', '344000', '南城县', null), ('344800', '344000', '金溪县', null), ('344900', '344000', '广昌县', null), ('350000', '350000', '晋安区', null), ('350001', '350000', '仓山区', null), ('350002', '350000', '台江区', null), ('350005', '350000', '马尾区', null), ('350006', '350000', '鼓楼区', null), ('350100', '350000', '闽侯县', null), ('350200', '350000', '长乐市', null), ('350300', '350000', '福清市', null), ('350400', '350000', '平潭县', null), ('350500', '350000', '连江县', null), ('350600', '350000', '罗源县', null), ('350700', '350000', '永泰县', null), ('350800', '350000', '闽清县', null), ('351101', '351100', '城厢区', null), ('351102', '351100', '涵江区', null), ('351103', '351100', '秀屿区', null), ('351104', '351100', '荔城区', null), ('351200', '351100', '仙游县', null), ('352000', '352000', '蕉城区', null), ('352200', '352000', '古田县', null), ('352300', '352000', '屏南县', null), ('353000', '353000', '延平区', null), ('353100', '353000', '建瓯市', null), ('353200', '353000', '顺昌县', null), ('353300', '365000', '将乐县', null), ('353400', '353000', '浦城县', null), ('353500', '353000', '松溪县', null), ('353600', '353000', '政和县', null), ('354000', '353000', '邵武市', null), ('354100', '353000', '光泽县', null), ('354200', '353000', '建阳市', null), ('354300', '353000', '武夷山市', null), ('354400', '365000', '泰宁县', null), ('354500', '365000', '建宁县', null), ('355000', '352000', '福安市', null), ('355100', '352000', '霞浦县', null), ('355200', '352000', '福鼎市', null), ('355300', '352000', '柘荣县', null), ('355400', '352000', '周宁县', null), ('355500', '352000', '寿宁县', null), ('361000', '361000', '集美区', null), ('361001', '361000', '思明区', null), ('361002', '361000', '海沧区', null), ('361003', '361000', '湖里区', null), ('361100', '361000', '同安区', null), ('361101', '361000', '翔安区', null), ('362000', '362000', '丰泽区', null), ('362001', '362000', '洛江区', null), ('362002', '362000', '鲤城区', null), ('362100', '362000', '惠安县', null), ('362101', '362000', '泉港区', null), ('362200', '362000', '晋江市', null), ('362300', '362000', '南安市', null), ('362400', '362000', '安溪县', null), ('362500', '362000', '德化县', null), ('362600', '362000', '永春县', null), ('362700', '362000', '石狮市', null), ('363000', '363000', '芗城区', null), ('363001', '363000', '龙文区', null), ('363100', '363000', '龙海市', null), ('363200', '363000', '漳浦县', null), ('363300', '363000', '云霄县', null);
INSERT INTO `t_district` VALUES ('363400', '363000', '东山县', null), ('363500', '363000', '诏安县', null), ('363600', '363000', '南靖县', null), ('363700', '363000', '平和县', null), ('363800', '363000', '华安县', null), ('363900', '363000', '长泰县', null), ('364000', '364000', '新罗区', null), ('364100', '364000', '永定县', null), ('364200', '364000', '上杭县', null), ('364300', '364000', '武平县', null), ('364400', '364000', '漳平市', null), ('365000', '365000', '三元区', null), ('365001', '365000', '梅列区', null), ('365100', '365000', '尤溪县', null), ('365200', '365000', '明溪县', null), ('365300', '365000', '清流县', null), ('365400', '365000', '宁化县', null), ('365500', '365000', '沙县', null), ('366000', '365000', '永安市', null), ('366100', '365000', '大田县', null), ('366200', '364000', '连城县', null), ('366300', '364000', '长汀县', null), ('400010', '400000', '渝中区', null), ('400021', '400000', '江北区', null), ('400030', '400000', '沙坪坝区', null), ('400051', '400000', '九龙坡区', null), ('400060', '400000', '南岸区', null), ('400080', '400000', '大渡口区', null), ('400700', '400000', '北碚区', null), ('400800', '400000', '万盛区', null), ('400900', '400000', '双桥区', null), ('401120', '400000', '渝北区', null), ('401220', '400000', '长寿区', null), ('401320', '400000', '巴南区', null), ('401420', '400000', '綦江县', null), ('401520', '400000', '合川区', null), ('402160', '400000', '永川区', null), ('402260', '400000', '江津区', null), ('402360', '400000', '大足县', null), ('402460', '400000', '荣昌县', null), ('402560', '400000', '铜梁县', null), ('402660', '400000', '潼南县', null), ('402760', '400000', '璧山县', null), ('404100', '400000', '万州区', null), ('404300', '400000', '忠县', null), ('404500', '400000', '云阳县', null), ('404600', '400000', '奉节县', null), ('404700', '400000', '巫山县', null), ('405200', '400000', '梁平县', null), ('405400', '400000', '开县', null), ('405800', '400000', '巫溪县', null), ('405900', '400000', '城口县', null), ('408000', '400000', '涪陵区', null), ('408200', '400000', '丰都县', null), ('408300', '400000', '垫江县', null), ('408400', '400000', '南川区', null), ('408500', '400000', '武隆县', null), ('409000', '400000', '黔江区', null), ('409100', '400000', '石柱土家族自治县', null), ('409600', '400000', '彭水苗族土家族自治县', null), ('409800', '400000', '酉阳土家族苗族自治县', null), ('409900', '400000', '秀山土家族苗族自治县', null), ('410000', '410000', '天心区', null), ('410001', '410000', '岳麓区', null), ('410002', '410000', '开福区', null), ('410006', '410000', '雨花区', null), ('410010', '410000', '芙蓉区', null), ('410100', '410000', '长沙县', null), ('410200', '410000', '望城县', null), ('410300', '410000', '浏阳市', null), ('410400', '414000', '平江县', null), ('410500', '414000', '湘阴县', null), ('410600', '410000', '宁乡县', null), ('410703', '453000', '卫滨区', null), ('411100', '411100', '岳塘区', null), ('411101', '411100', '雨湖区', null), ('411200', '411100', '湘潭县', null), ('411300', '411100', '韶山市', null), ('411400', '411100', '湘乡市', null), ('412000', '412000', '天元区', null), ('412001', '412000', '株洲县', null), ('412002', '412000', '石峰区', null), ('412003', '412000', '芦淞区', null), ('412006', '412000', '荷塘区', null), ('412200', '412000', '醴陵市', null), ('412300', '412000', '攸县', null), ('412400', '412000', '茶陵县', null), ('412500', '412000', '炎陵县', null), ('413000', '413000', '资阳区', null), ('413002', '413000', '赫山区', null), ('413100', '413000', '沅江市', null), ('413200', '413000', '南县', null), ('413400', '413000', '桃江县', null), ('413500', '413000', '安化县', null), ('414000', '414000', '岳阳楼区', null), ('414001', '414000', '云溪区', null), ('414002', '414000', '君山区', null), ('414100', '414000', '岳阳县', null), ('414200', '414000', '华容县', null), ('414300', '414000', '临湘市', null);
INSERT INTO `t_district` VALUES ('414400', '414000', '汨罗市', null), ('415000', '415000', '武陵区', null), ('415100', '415000', '鼎城区', null), ('415200', '415000', '临澧县', null), ('415300', '415000', '石门县', null), ('415400', '415000', '津市市', null), ('415500', '415000', '澧县', null), ('415600', '415000', '安乡县', null), ('415700', '415000', '桃源县', null), ('415900', '415000', '汉寿县', null), ('416000', '416000', '吉首市', null), ('416100', '416000', '泸溪县', null), ('416200', '416000', '凤凰县', null), ('416300', '416000', '古丈县', null), ('416400', '416000', '花垣县', null), ('416500', '416000', '保靖县', null), ('416700', '416000', '永顺县', null), ('416800', '416000', '龙山县', null), ('417000', '417000', '娄星区', null), ('417100', '417000', '涟源市', null), ('417500', '417000', '冷水江市', null), ('417600', '417000', '新化县', null), ('417700', '417000', '双峰县', null), ('418000', '418000', '中方县', null), ('418001', '418000', '鹤城区', null), ('418200', '418000', '洪江市', null), ('418300', '418000', '会同县', null), ('418400', '418000', '靖州苗族侗族自治县', null), ('418500', '418000', '通道侗族自治县', null), ('419100', '418000', '芷江侗族自治县', null), ('419200', '418000', '新晃侗族自治县', null), ('419300', '418000', '溆浦县', null), ('419400', '418000', '麻阳苗族自治县', null), ('419500', '418000', '辰溪县', null), ('419600', '418000', '沅陵县', null), ('421000', '421200', '南岳区', null), ('421001', '421200', '珠晖区', null), ('421002', '421200', '石鼓区', null), ('421003', '421200', '蒸湘区', null), ('421006', '421200', '雁峰区', null), ('421100', '421200', '衡南县', null), ('421200', '421200', '衡阳县', null), ('421300', '421200', '衡山县', null), ('421400', '421200', '衡东县', null), ('421500', '421200', '常宁市', null), ('421600', '421200', '祁东县', null), ('421800', '421200', '耒阳市', null), ('422000', '422000', '北塔区', null), ('422001', '422000', '双清区', null), ('422003', '422000', '大祥区', null), ('422100', '422000', '邵阳县', null), ('422200', '422000', '隆回县', null), ('422300', '422000', '洞口县', null), ('422400', '422000', '武冈市', null), ('422500', '422000', '城步苗族自治县', null), ('422600', '422000', '绥宁县', null), ('422700', '422000', '新宁县', null), ('422800', '422000', '邵东县', null), ('422900', '422000', '新邵县', null), ('423000', '423000', '北湖区', null), ('423001', '423000', '苏仙区', null), ('423300', '423000', '永兴县', null), ('423400', '423000', '资兴市', null), ('423500', '423000', '桂东县', null), ('423600', '423000', '安仁县', null), ('424100', '423000', '汝城县', null), ('424200', '423000', '宜章县', null), ('424300', '423000', '临武县', null), ('424400', '423000', '桂阳县', null), ('424500', '423000', '嘉禾县', null), ('425000', '425000', '冷水滩区', null), ('425001', '425000', '零陵区', null), ('425200', '425000', '双牌县', null), ('425300', '425000', '道县', null), ('425400', '425000', '江永县', null), ('425500', '425000', '江华瑶族自治县', null), ('425600', '425000', '宁远县', null), ('425700', '425000', '新田县', null), ('425800', '425000', '蓝山县', null), ('425900', '425000', '东安县', null), ('426100', '425000', '祁阳县', null), ('427000', '427000', '永定区', null), ('427100', '427000', '桑植县', null), ('427200', '427000', '慈利县', null), ('427400', '427000', '武陵源区', null), ('430000', '430000', '武昌区', null), ('430014', '430000', '江岸区', null), ('430022', '430000', '江汉区', null), ('430030', '430000', '硚口区', null), ('430040', '430000', '东西湖区', null), ('430050', '430000', '汉阳区', null), ('430070', '430000', '洪山区', null), ('430080', '430000', '青山区', null), ('430090', '430000', '汉南区', null), ('430100', '430000', '蔡甸区', null), ('430200', '430000', '江夏区', null), ('430300', '430000', '黄陂区', null), ('431400', '430000', '新洲区', null), ('431701', '431700', '九真镇', null), ('431702', '431700', '佛子山镇', null);
INSERT INTO `t_district` VALUES ('431703', '431700', '候口街道', null), ('431704', '431700', '净潭乡', null), ('431705', '431700', '卢市镇', null), ('431706', '431700', '多宝镇', null), ('431707', '431700', '多祥镇', null), ('431708', '431700', '小板镇', null), ('431709', '431700', '岳口镇', null), ('431710', '431700', '干驿镇', null), ('431711', '431700', '张港镇', null), ('431712', '431700', '彭市镇', null), ('431713', '431700', '拖市镇', null), ('431714', '431700', '杨林街道', null), ('431715', '431700', '横林镇', null), ('431716', '431700', '汪场镇', null), ('431717', '431700', '沉湖管委会', null), ('431718', '431700', '渔薪镇', null), ('431719', '431700', '白茅湖农场', null), ('431720', '431700', '皂市镇', null), ('431721', '431700', '石家河镇', null), ('431722', '431700', '竟陵街道', null), ('431723', '431700', '胡市镇', null), ('431724', '431700', '蒋场镇', null), ('431725', '431700', '蒋湖农场', null), ('431726', '431700', '马湾镇', null), ('431727', '431700', '麻洋镇', null), ('431728', '431700', '黄潭镇', null), ('431800', '448000', '京山县', null), ('431900', '448000', '钟祥市', null), ('432100', '432000', '孝南区', null), ('432200', '436000', '华容区', null), ('432300', '432000', '汉川市', null), ('432400', '432000', '应城市', null), ('432500', '432000', '云梦县', null), ('432600', '432000', '安陆市', null), ('432700', '441300', '广水市', null), ('432800', '432000', '大悟县', null), ('432900', '432000', '孝昌县', null), ('433001', '433000', '三伏潭镇', null), ('433002', '433000', '九合垸原种场', null), ('433003', '433000', '五湖渔场', null), ('433004', '433000', '工业园区', null), ('433005', '433000', '干河街道', null), ('433006', '433000', '张沟镇', null), ('433007', '433000', '彭场镇', null), ('433008', '433000', '排湖风景区', null), ('433009', '433000', '杨林尾镇', null), ('433010', '433000', '毛嘴镇', null), ('433011', '433000', '沔城回族镇', null), ('433012', '433000', '沙嘴街道', null), ('433013', '433000', '沙湖原种场', null), ('433014', '433000', '沙湖镇', null), ('433015', '433000', '畜禽良种场', null), ('433016', '433000', '胡场镇', null), ('433017', '433000', '西流河镇', null), ('433018', '433000', '豆河镇', null), ('433019', '433000', '赵西垸林场', null), ('433020', '433000', '通海口镇', null), ('433021', '433000', '郑场镇', null), ('433022', '433000', '郭河镇', null), ('433023', '433000', '长倘口镇', null), ('433024', '433000', '陈场镇', null), ('433025', '433000', '龙华山街道', null), ('433101', '433100', '后湖管理区', null), ('433102', '433100', '周矶管理区', null), ('433103', '433100', '周矶街道', null), ('433104', '433100', '园林街道', null), ('433105', '433100', '广华街道', null), ('433106', '433100', '张金镇', null), ('433107', '433100', '总口管理区', null), ('433108', '433100', '杨市街道', null), ('433109', '433100', '江汉石油管理局', null), ('433110', '433100', '泰丰街道', null), ('433111', '433100', '浩口原种场', null), ('433112', '433100', '浩口镇', null), ('433113', '433100', '渔洋镇', null), ('433114', '433100', '潜江经济开发区', null), ('433115', '433100', '熊口管理区', null), ('433116', '433100', '熊口镇', null), ('433117', '433100', '王场镇', null), ('433118', '433100', '白鹭湖管理区', null), ('433119', '433100', '积玉口镇', null), ('433120', '433100', '竹根滩镇', null), ('433121', '433100', '老新镇', null), ('433122', '433100', '运粮湖管理区', null), ('433123', '433100', '高场街道', null), ('433124', '433100', '高石碑镇', null), ('433125', '433100', '龙湾镇', null), ('433200', '434000', '洪湖市', null), ('433300', '434000', '监利县', null), ('434000', '434000', '沙市区', null), ('434020', '434000', '荆州区', null), ('434100', '434000', '江陵县', null), ('434200', '434000', '松滋市', null), ('434300', '434000', '公安县', null), ('434400', '434000', '石首市', null), ('435000', '435000', '下陆区', null), ('435001', '435000', '西塞山区', null), ('435002', '435000', '黄石港区', null), ('435003', '435000', '团城山开发区', null), ('435006', '435000', '铁山区', null);
INSERT INTO `t_district` VALUES ('435100', '435000', '大冶市', null), ('435200', '435000', '阳新县', null), ('435300', '438000', '蕲春县', null), ('435400', '438000', '武穴市', null), ('435500', '438000', '黄梅县', null), ('436000', '436000', '梁子湖区', null), ('436006', '436000', '鄂城区', null), ('437000', '437000', '咸安区', null), ('437200', '437000', '嘉鱼县', null), ('437300', '437000', '赤壁市', null), ('437400', '437000', '通城县', null), ('437500', '437000', '崇阳县', null), ('437600', '437000', '通山县', null), ('438000', '438000', '团风县', null), ('438011', '438000', '黄州区', null), ('438200', '438000', '浠水县', null), ('438300', '438000', '麻城市', null), ('438400', '438000', '红安县', null), ('438600', '438000', '罗田县', null), ('438700', '438000', '英山县', null), ('441000', '441000', '襄城区', null), ('441003', '441000', '樊城区', null), ('441100', '441000', '襄阳区', null), ('441200', '441000', '枣阳市', null), ('441300', '441300', '曾都区', null), ('441400', '441000', '宜城市', null), ('441500', '441000', '南漳县', null), ('441600', '441000', '保康县', null), ('441700', '441000', '谷城县', null), ('441800', '441000', '老河口市', null), ('442000', '442000', '张湾区', null), ('442005', '442000', '茅箭区', null), ('442100', '442000', '房县', null), ('442200', '442000', '竹山县', null), ('442300', '442000', '竹溪县', null), ('442401', '442400', '下谷坪土家族乡', null), ('442402', '442400', '九湖镇', null), ('442403', '442400', '宋洛乡', null), ('442404', '442400', '新华镇', null), ('442405', '442400', '木鱼镇', null), ('442406', '442400', '松柏镇', null), ('442407', '442400', '红坪镇', null), ('442408', '442400', '阳日镇', null), ('442500', '442000', '郧县', null), ('442600', '442000', '郧西县', null), ('442700', '442000', '丹江口市', null), ('443000', '443000', '伍家岗区', null), ('443002', '443000', '宜都市', null), ('443007', '443000', '猇亭区', null), ('443008', '443000', '西陵区', null), ('443009', '443000', '点军区', null), ('443100', '443000', '夷陵区', null), ('443200', '443000', '枝江市', null), ('443400', '443000', '五峰土家族自治县', null), ('443500', '443000', '长阳土家族自治县', null), ('443600', '443000', '秭归县', null), ('443700', '443000', '兴山县', null), ('444100', '443000', '当阳市', null), ('444200', '443000', '远安县', null), ('444300', '445000', '巴东县', null), ('445000', '445000', '恩施市', null), ('445300', '445000', '建始县', null), ('445400', '445000', '利川市', null), ('445500', '445000', '宣恩县', null), ('445600', '445000', '咸丰县', null), ('445700', '445000', '来凤县', null), ('445800', '445000', '鹤峰县', null), ('448000', '448000', '东宝区', null), ('448159', '448000', '掇刀区', null), ('448200', '448000', '沙洋县', null), ('450000', '453000', '获嘉县', null), ('450001', '450000', '中原区', null), ('450002', '450000', '金水区', null), ('450015', '450000', '二七区', null), ('450016', '450000', '管城回族区', null), ('450041', '450000', '上街区', null), ('450044', '450000', '惠济区', null), ('450101', '450000', '荥阳市', null), ('451100', '450000', '新郑市', null), ('451200', '450000', '巩义市', null), ('451450', '450000', '中牟县', null), ('452370', '450000', '新密市', null), ('452470', '450000', '登封市', null), ('452570', '461000', '禹州市', null), ('452670', '461000', '襄城县', null), ('453000', '472000', '湖滨区', null), ('453003', '453000', '凤泉区', null), ('453005', '453000', '牧野区', null), ('453100', '453000', '卫辉市', null), ('453200', '453000', '延津县', null), ('453300', '453000', '封丘县', null), ('453400', '453000', '长垣县', null), ('453500', '453000', '原阳县', null), ('453600', '453000', '辉县市', null), ('453700', '453000', '新乡县', null), ('454002', '454150', '山阳区', null), ('454150', '454150', '解放区', null), ('454191', '454150', '中站区', null), ('454362', '454150', '修武县', null), ('454450', '454150', '博爱县', null);
INSERT INTO `t_district` VALUES ('454550', '454150', '沁阳市', null), ('454601', '454650', '下冶镇', null), ('454602', '454650', '五龙口镇', null), ('454603', '454650', '克井镇', null), ('454604', '454650', '北海街道', null), ('454605', '454650', '坡头镇', null), ('454606', '454650', '大峪镇', null), ('454607', '454650', '天坛街道', null), ('454608', '454650', '思礼镇', null), ('454609', '454650', '承留镇', null), ('454610', '454650', '梨林镇', null), ('454611', '454650', '沁园街道', null), ('454612', '454650', '济水街道', null), ('454613', '454650', '玉泉街道', null), ('454614', '454650', '王屋镇', null), ('454615', '454650', '轵城镇', null), ('454616', '454650', '邵原镇', null), ('454750', '454150', '孟州市', null), ('454850', '454150', '温县', null), ('454950', '454150', '武陟县', null), ('455000', '455000', '龙安区', null), ('455001', '455000', '殷都区', null), ('455002', '455000', '文峰区', null), ('455006', '455000', '北关区', null), ('455100', '455000', '安阳县', null), ('456150', '455000', '汤阴县', null), ('456250', '458000', '浚县', null), ('456300', '455000', '内黄县', null), ('456400', '455000', '滑县', null), ('456500', '455000', '林州市', null), ('456750', '458000', '淇县', null), ('457000', '457000', '濮阳县', null), ('457300', '457000', '清丰县', null), ('457400', '457000', '南乐县', null), ('457500', '457000', '范县', null), ('457600', '457000', '台前县', null), ('458000', '453000', '红旗区', null), ('458006', '458000', '淇滨区', null), ('458008', '458000', '山城区', null), ('458010', '458000', '鹤山区', null), ('461000', '461000', '魏都区', null), ('461100', '461000', '许昌县', null), ('461200', '461000', '鄢陵县', null), ('461300', '466000', '扶沟县', null), ('461400', '466000', '太康县', null), ('461500', '461000', '长葛市', null), ('462000', '462000', '郾城区', null), ('462002', '462000', '源汇区', null), ('462003', '462000', '召陵区', null), ('462300', '467000', '叶县', null), ('462400', '462000', '舞阳县', null), ('462500', '467000', '舞钢市', null), ('462600', '462000', '临颍县', null), ('463000', '463000', '驿城区', null), ('463100', '463000', '遂平县', null), ('463200', '463000', '确山县', null), ('463300', '463000', '汝南县', null), ('463400', '463000', '平舆县', null), ('463500', '463000', '新蔡县', null), ('463600', '463000', '正阳县', null), ('463700', '463000', '泌阳县', null), ('463800', '463000', '上蔡县', null), ('463900', '463000', '西平县', null), ('464000', '464000', '浉河区', null), ('464006', '464000', '羊山新区', null), ('464017', '464000', '上天梯非金属矿管理区', null), ('464031', '464000', '南湾湖风景区', null), ('464094', '464000', '信阳高新技术产业开发区', null), ('464100', '464000', '平桥区', null), ('464134', '464000', '鸡公山管理区', null), ('464200', '464000', '罗山县', null), ('464300', '464000', '息县', null), ('464400', '464000', '淮滨县', null), ('465141', '464000', '潢川经济技术开发区', null), ('465150', '464000', '潢川县', null), ('465250', '464000', '固始县', null), ('465350', '464000', '商城县', null), ('465450', '464000', '光山县', null), ('465550', '464000', '新县', null), ('466000', '466000', '川汇区', null), ('466100', '466000', '商水县', null), ('466200', '466000', '项城市', null), ('466300', '466000', '沈丘县', null), ('466600', '466000', '西华县', null), ('466700', '466000', '淮阳县', null), ('467001', '467000', '湛河区', null), ('467021', '467000', '卫东区', null), ('467041', '467000', '新华区', null), ('467043', '467000', '石龙区', null), ('467100', '467000', '郏县', null), ('467300', '467000', '鲁山县', null), ('467400', '467000', '宝丰县', null), ('467500', '467000', '汝州市', null), ('471000', '471000', '老城区', null), ('471002', '471000', '瀍河回族区', null), ('471003', '471000', '涧西区', null), ('471012', '471000', '吉利区', null), ('471023', '471000', '洛龙区', null), ('471041', '471000', '西工区', null), ('471100', '471000', '孟津县', null);
INSERT INTO `t_district` VALUES ('471200', '471000', '汝阳县', null), ('471300', '471000', '伊川县', null), ('471400', '471000', '嵩县', null), ('471500', '471000', '栾川县', null), ('471600', '471000', '宜阳县', null), ('471700', '471000', '洛宁县', null), ('471800', '471000', '新安县', null), ('471900', '471000', '偃师市', null), ('472000', '457000', '华龙区', null), ('472100', '472000', '陕县', null), ('472200', '472000', '卢氏县', null), ('472300', '472000', '义马市', null), ('472400', '472000', '渑池县', null), ('472500', '472000', '灵宝市', null), ('473000', '473000', '宛城区', null), ('473001', '473000', '南召县', null), ('473002', '473000', '卧龙区', null), ('473200', '473000', '方城县', null), ('473300', '473000', '社旗县', null), ('473400', '473000', '唐河县', null), ('473500', '473000', '新野县', null), ('474150', '473000', '邓州市', null), ('474250', '473000', '镇平县', null), ('474350', '473000', '内乡县', null), ('474450', '473000', '淅川县', null), ('474550', '473000', '西峡县', null), ('474750', '473000', '桐柏县', null), ('475000', '475000', '金明区', null), ('475001', '475000', '顺河回族区', null), ('475003', '475000', '禹王台区', null), ('475004', '475000', '开封县', null), ('475005', '475000', '龙亭区', null), ('475007', '475000', '鼓楼区', null), ('475200', '475000', '杞县', null), ('475300', '475000', '兰考县', null), ('475400', '475000', '通许县', null), ('475500', '475000', '尉氏县', null), ('476000', '476000', '梁园区', null), ('476005', '476000', '睢阳区', null), ('476200', '476000', '柘城县', null), ('476300', '476000', '虞城县', null), ('476400', '476000', '夏邑县', null), ('476600', '476600', '十八里镇', null), ('476601', '476600', '王集镇', null), ('476602', '476600', '顺和镇', null), ('476606', '476600', '马桥镇', null), ('476612', '476600', '高庄镇', null), ('476613', '476600', '苗桥镇', null), ('476614', '476600', '卧龙镇', null), ('476615', '476600', '茴村镇', null), ('476616', '476600', '刘河镇', null), ('476617', '476600', '陈集镇', null), ('476621', '476600', '新桥镇', null), ('476623', '476600', '裴桥镇', null), ('476624', '476600', '李寨镇', null), ('476625', '476600', '黄口镇', null), ('476632', '476600', '龙岗镇', null), ('476633', '476600', '酂城镇', '商代时期，为邑'), ('476636', '476600', '双桥镇', null), ('476641', '476600', '芒山镇', '古称砀，又名山城集!'), ('476642', '476600', '条河镇', null), ('476643', '476600', '薛湖镇', null), ('476645', '476600', '太丘镇', null), ('476646', '476600', '蒋口镇', null), ('476648', '476600', '酂阳镇', null), ('476700', '476000', '宁陵县', null), ('476800', '476000', '民权县', null), ('476900', '476000', '睢县', null), ('477150', '466000', '郸城县', null), ('477200', '466000', '鹿邑县', null), ('510000', '510000', '天河区', null), ('510001', '510000', '海珠区', null), ('510002', '510000', '白云区', null), ('510010', '510000', '荔湾区', null), ('510020', '510000', '萝岗区', null), ('510030', '510000', '越秀区', null), ('510060', '510000', '东山区', null), ('510380', '510000', '芳村区', null), ('510700', '510000', '黄埔区', null), ('510800', '510000', '花都区', null), ('510900', '510000', '从化市', null), ('511100', '512000', '新丰县', null), ('511300', '510000', '增城市', null), ('511400', '510000', '番禺区', null), ('511500', '511500', '清城区', null), ('511600', '511500', '佛冈县', null), ('511800', '511500', '清新县', null), ('512000', '512000', '武江区', null), ('512001', '512000', '浈江区', null), ('512100', '512000', '曲江区', null), ('512200', '512000', '乐昌市', null), ('512300', '512000', '仁化县', null), ('512400', '512000', '南雄市', null), ('512500', '512000', '始兴县', null), ('512600', '512000', '乳源瑶族自治县', null), ('512601', '512000', '翁源县', null), ('513000', '511500', '英德市', null), ('513100', '511500', '阳山县', null), ('513200', '511500', '连山壮族瑶族自治县', null), ('513300', '511500', '连南瑶族自治县', null);
INSERT INTO `t_district` VALUES ('513400', '511500', '连州市', null), ('514000', '514000', '梅江区', null), ('514100', '514000', '蕉岭县', null), ('514200', '514000', '大埔县', null), ('514300', '514000', '丰顺县', null), ('514400', '514000', '五华县', null), ('514500', '514000', '兴宁市', null), ('514600', '514000', '平远县', null), ('514700', '514000', '梅县', null), ('515000', '515000', '濠江区', null), ('515003', '515000', '金平区', null), ('515004', '515000', '龙湖区', null), ('515100', '515000', '潮南区', null), ('515101', '515000', '潮阳区', null), ('515200', '522000', '惠来县', null), ('515300', '522000', '普宁市', null), ('515400', '522000', '揭西县', null), ('515500', '522000', '揭东县', null), ('515600', '521000', '潮安县', null), ('515700', '521000', '饶平县', null), ('515800', '515000', '澄海区', null), ('515900', '515000', '南澳县', null), ('516000', '516000', '惠城区', null), ('516100', '516000', '博罗县', null), ('516200', '516000', '惠阳区', null), ('516300', '516000', '惠东县', null), ('516400', '516600', '海丰县', null), ('516500', '516600', '陆丰市', null), ('516600', '516600', '城区', null), ('516601', '516600', '红海湾经济开发试验区', null), ('516700', '516600', '陆河县', null), ('516800', '516000', '龙门县', null), ('517000', '517000', '源城区', null), ('517100', '517000', '连平县', null), ('517200', '517000', '和平县', null), ('517300', '517000', '龙川县', null), ('517400', '517000', '紫金县', null), ('517500', '517000', '东源县', null), ('518000', '518000', '南山区', null), ('518001', '518000', '盐田区', null), ('518002', '518000', '福田区', null), ('518003', '518000', '罗湖区', null), ('518100', '518000', '宝安区', null), ('518101', '518000', '龙岗区', null), ('519000', '519000', '香洲区', null), ('519090', '519000', '金湾区', null), ('519100', '519000', '斗门区', null), ('521000', '521000', '枫溪区', null), ('521001', '521000', '湘桥区', null), ('522000', '522000', '东山区', null), ('522001', '522000', '榕城区', null), ('522002', '522000', '经济开发试验区', null), ('523000', '523000', '茶山镇', null), ('523001', '523000', '长安镇', null), ('523002', '523000', '常平镇', null), ('523003', '523000', '大朗镇', null), ('523004', '523000', '大岭山镇', null), ('523005', '523000', '道滘镇', null), ('523006', '523000', '东城街道', null), ('523007', '523000', '东莞生态园', null), ('523008', '523000', '东坑镇', null), ('523009', '523000', '凤岗镇', null), ('523010', '523000', '高埗镇', null), ('523011', '523000', '莞城街道', null), ('523012', '523000', '横沥镇', null), ('523013', '523000', '洪梅镇', null), ('523014', '523000', '厚街镇', null), ('523015', '523000', '虎门港管委会', null), ('523016', '523000', '虎门镇', null), ('523017', '523000', '黄江镇', null), ('523018', '523000', '寮步镇', null), ('523019', '523000', '麻涌镇', null), ('523020', '523000', '南城街道', null), ('523021', '523000', '企石镇', null), ('523022', '523000', '桥头镇', null), ('523023', '523000', '清溪镇', null), ('523024', '523000', '沙田镇', null), ('523025', '523000', '石碣镇', null), ('523026', '523000', '石龙镇', null), ('523027', '523000', '石排镇', null), ('523028', '523000', '松山湖管委会', null), ('523029', '523000', '塘厦镇', null), ('523030', '523000', '万江街道', null), ('523032', '523000', '望牛墩镇', null), ('523033', '523000', '谢岗镇', null), ('523034', '523000', '樟木头镇', null), ('523035', '523000', '中堂镇', null), ('524000', '524000', '东海岛', null), ('524001', '524000', '坡头区', null), ('524002', '524000', '开发区', null), ('524004', '524000', '赤坎区', null), ('524008', '524000', '霞山区', null), ('524009', '524000', '麻章区', null), ('524100', '524000', '徐闻县', null), ('524200', '524000', '雷州市', null), ('524300', '524000', '遂溪县', null), ('524400', '524000', '廉江市', null), ('524500', '524000', '吴川市', null), ('525000', '525000', '茂南区', null), ('525001', '525000', '茂港区', null);
INSERT INTO `t_district` VALUES ('525100', '525000', '化州市', null), ('525200', '525000', '高州市', null), ('525300', '525000', '信宜市', null), ('525400', '525000', '电白县', null), ('526000', '526000', '端州区', null), ('526001', '526000', '鼎湖区', null), ('526100', '526000', '高要市', null), ('526200', '526000', '四会市', null), ('526300', '526000', '广宁县', null), ('526400', '526000', '怀集县', null), ('526500', '526000', '封开县', null), ('526600', '526000', '德庆县', null), ('527100', '527300', '郁南县', null), ('527200', '527300', '罗定市', null), ('527300', '527300', '云城区', null), ('527400', '527300', '新兴县', null), ('527500', '527300', '云安县', null), ('528000', '528000', '禅城区', null), ('528001', '528000', '顺德区', null), ('528100', '528000', '三水区', null), ('528200', '528000', '南海区', null), ('528400', '528400', '板芙镇', null), ('528401', '528400', '大涌镇', null), ('528402', '528400', '东凤镇', null), ('528403', '528400', '东区街道', null), ('528404', '528400', '东升镇', null), ('528405', '528400', '阜沙镇', null), ('528406', '528400', '港口镇', null), ('528407', '528400', '古镇镇', null), ('528408', '528400', '横栏镇', null), ('528409', '528400', '黄圃镇', null), ('528410', '528400', '火炬开发区街道', null), ('528411', '528400', '民众镇', null), ('528412', '528400', '南朗镇', null), ('528413', '528400', '南区街道', null), ('528414', '528400', '南头镇', null), ('528415', '528400', '三角镇', null), ('528416', '528400', '三乡镇', null), ('528417', '528400', '沙溪镇', null), ('528418', '528400', '神湾镇', null), ('528419', '528400', '石岐区街道', null), ('528420', '528400', '坦洲镇', null), ('528421', '528400', '五桂山街道', null), ('528422', '528400', '西区街道', null), ('528423', '528400', '小榄镇', null), ('528500', '528000', '高明区', null), ('529000', '529000', '江海区', null), ('529001', '529000', '蓬江区', null), ('529100', '529000', '新会区', null), ('529200', '529000', '台山市', null), ('529300', '529000', '开平市', null), ('529400', '529000', '恩平市', null), ('529500', '529500', '江城区', null), ('529600', '529500', '阳春市', null), ('529700', '529000', '鹤山市', null), ('529800', '529500', '阳西县', null), ('529900', '529500', '阳东县', null), ('530000', '530000', '西乡塘区', null), ('530001', '530000', '兴宁区', null), ('530002', '530000', '江南区', null), ('530005', '530000', '青秀区', null), ('530100', '530000', '武鸣县', null), ('530200', '530000', '良庆区', null), ('530201', '530000', '邕宁区', null), ('530300', '530000', '横县', null), ('530400', '530000', '宾阳县', null), ('530500', '530000', '上林县', null), ('530600', '530000', '马山县', null), ('530700', '547000', '都安瑶族自治县', null), ('530800', '547000', '大化瑶族自治县', null), ('531400', '533000', '平果县', null), ('531500', '533000', '田东县', null), ('532100', '532200', '扶绥县', null), ('532200', '532200', '江洲区', null), ('532300', '532200', '大新县', null), ('532400', '532200', '龙州县', null), ('532500', '532200', '宁明县', null), ('532600', '532200', '凭祥市', null), ('532700', '530000', '隆安县', null), ('532800', '532200', '天等县', null), ('533000', '533000', '右江区', null), ('533100', '533000', '凌云县', null), ('533200', '533000', '乐业县', null), ('533300', '533000', '田林县', null), ('533400', '533000', '隆林各族自治县', null), ('533500', '533000', '西林县', null), ('533600', '533000', '田阳县', null), ('533700', '533000', '德保县', null), ('533800', '533000', '靖西县', null), ('533900', '533000', '那坡县', null), ('535000', '535000', '钦北区', null), ('535002', '535000', '钦南区', null), ('535300', '535000', '浦北县', null), ('535400', '535000', '灵山县', null), ('535500', '538000', '上思县', null), ('536001', '536000', '海城区', null), ('536002', '536000', '铁山港区', null), ('536003', '536000', '银海区', null), ('536100', '536000', '合浦县', null), ('537000', '537000', '玉州区', null);
INSERT INTO `t_district` VALUES ('537100', '537100', '港北区', null), ('537101', '537100', '港南区', null), ('537102', '537100', '覃塘区', null), ('537200', '537100', '桂平市', null), ('537300', '537100', '平南县', null), ('537400', '537000', '北流市', null), ('537500', '537000', '容县', null), ('537600', '537000', '博白县', null), ('537700', '537000', '陆川县', null), ('537800', '537000', '兴业县', null), ('538000', '538000', '港口区', null), ('538001', '538000', '防城区', null), ('538100', '538000', '东兴市', null), ('541000', '541000', '七星区', null), ('541001', '541000', '叠彩区', null), ('541002', '541000', '秀峰区', null), ('541003', '541000', '象山区', null), ('541005', '541000', '雁山区', null), ('541100', '541000', '临桂县', null), ('541200', '541000', '灵川县', null), ('541300', '541000', '兴安县', null), ('541400', '541000', '资源县', null), ('541500', '541000', '全州县', null), ('541600', '541000', '灌阳县', null), ('541700', '541000', '龙胜各族自治县', null), ('541800', '541000', '永福县', null), ('541900', '541000', '阳朔县', null), ('542400', '541000', '平乐县', null), ('542500', '541000', '恭城瑶族自治县', null), ('542600', '542800', '钟山县', null), ('542700', '542800', '富川瑶族自治县', null), ('542800', '542800', '八步区', null), ('543000', '543000', '万秀区', null), ('543001', '543000', '蝶山区', null), ('543002', '543000', '长洲区', null), ('543100', '543000', '苍梧县', null), ('543200', '543000', '岑溪市', null), ('543300', '543000', '藤县', null), ('545000', '545000', '城中区', null), ('545001', '545000', '柳北区', null), ('545002', '545000', '柳南区', null), ('545003', '545000', '鱼峰区', null), ('545100', '545000', '柳江县', null), ('545200', '545000', '柳城县', null), ('545300', '545000', '融水苗族自治县', null), ('545400', '545000', '融安县', null), ('545500', '545000', '三江侗族自治县', null), ('545600', '545000', '鹿寨县', null), ('545700', '546100', '金秀瑶族自治县', null), ('545800', '546100', '象州县', null), ('545900', '546100', '武宣县', null), ('546100', '546100', '兴宾区', null), ('546200', '546100', '忻城县', null), ('546300', '547000', '宜州市', null), ('546400', '547000', '罗城仫佬族自治县', null), ('546500', '546100', '合山市', null), ('546600', '541000', '荔蒲县', null), ('546700', '543000', '蒙山县', null), ('546800', '542800', '昭平县', null), ('547000', '547000', '金城江区', null), ('547100', '547000', '环江毛南族自治县', null), ('547200', '547000', '南丹县', null), ('547300', '547000', '天峨县', null), ('547400', '547000', '东兰县', null), ('547500', '547000', '巴马瑶族自治县', null), ('547600', '547000', '凤山县', null), ('550000', '550000', '乌当区', null), ('550001', '550000', '云岩区', null), ('550002', '550000', '南明区', null), ('550003', '550000', '小河区', null), ('550008', '550000', '白云区', null), ('550009', '550000', '花溪区', null), ('550100', '558000', '罗甸县', null), ('550200', '550000', '修文县', null), ('550300', '550000', '开阳县', null), ('550400', '558000', '瓮安县', null), ('550500', '558000', '福泉市', null), ('550600', '558000', '惠水县', null), ('550700', '558000', '长顺县', null), ('550800', '561000', '紫云苗族布依族自治县', null), ('551100', '550000', '息烽县', null), ('551200', '558000', '龙里县', null), ('551300', '558000', '贵定县', null), ('551400', '550000', '清镇市', null), ('551500', '551700', '黔西县', null), ('551600', '551700', '大方县', null), ('551700', '551700', '毕节市', null), ('551800', '551700', '金沙县', null), ('552100', '551700', '织金县', null), ('552200', '562400', '册亨县', null), ('552300', '562400', '望谟县', null), ('552400', '562400', '安龙县', null), ('553000', '553000', '钟山区', null), ('553100', '551700', '威宁彝族回族苗族自治县', null), ('553200', '551700', '赫章县', null), ('553300', '551700', '纳雍县', null), ('553400', '553000', '六枝特区', null), ('553500', '553000', '盘县', null), ('553600', '553000', '水城县', null), ('554000', '554300', '玉屏侗族自治县', null);
INSERT INTO `t_district` VALUES ('554100', '554300', '松桃苗族自治县', null), ('554200', '554300', '万山特区', null), ('554300', '554300', '铜仁市', null), ('554400', '554300', '江口县', null), ('555100', '554300', '石阡县', null), ('555200', '554300', '印江土家族苗族自治县', null), ('556000', '556000', '凯里市', null), ('556100', '556000', '黄平县', null), ('556200', '556000', '施秉县', null), ('556300', '556000', '台江县', null), ('556400', '556000', '剑河县', null), ('556500', '556000', '三穗县', null), ('556600', '556000', '天柱县', null), ('556700', '556000', '锦屏县', null), ('557100', '556000', '雷山县', null), ('557200', '556000', '榕江县', null), ('557300', '556000', '黎平县', null), ('557400', '556000', '从江县', null), ('557500', '556000', '丹寨县', null), ('557600', '556000', '麻江县', null), ('557700', '556000', '镇远县', null), ('557800', '556000', '岑巩县', null), ('558000', '558000', '都匀市', null), ('558100', '558000', '三都水族自治县', null), ('558200', '558000', '独山县', null), ('558300', '558000', '平塘县', null), ('558400', '558000', '荔波县', null), ('561000', '561000', '西秀区', null), ('561100', '561000', '平坝县', null), ('561200', '561000', '镇宁布依族苗族自治县', null), ('561300', '561000', '关岭布依族苗族自治县', null), ('561400', '562400', '晴隆县', null), ('561500', '562400', '普安县', null), ('562100', '561000', '普定县', null), ('562200', '562400', '贞丰县', null), ('562300', '562400', '兴仁县', null), ('562400', '562400', '兴义市', null), ('563000', '563000', '汇川区', null), ('563001', '563000', '红花岗区', null), ('563100', '563000', '遵义县', null), ('563200', '563000', '桐梓县', null), ('563300', '563000', '绥阳县', null), ('563400', '563000', '正安县', null), ('563500', '563000', '道真仡佬族苗族自治县', null), ('564100', '563000', '湄潭县', null), ('564200', '563000', '凤冈县', null), ('564300', '563000', '务川仡佬族苗族自治县', null), ('564400', '563000', '余庆县', null), ('564500', '563000', '仁怀市', null), ('564600', '563000', '习水县', null), ('564700', '563000', '赤水市', null), ('565100', '554300', '思南县', null), ('565200', '554300', '德江县', null), ('565300', '554300', '沿河土家族自治县', null), ('570101', '570100', '秀英区', null), ('570102', '570100', '美兰区', null), ('570103', '570100', '龙华区', null), ('571100', '570100', '琼山区', null), ('571201', '571200', '定城镇', null), ('571202', '571200', '富文镇', null), ('571203', '571200', '岭口镇', null), ('571204', '571200', '新竹镇', null), ('571205', '571200', '翰林镇', null), ('571206', '571200', '雷鸣镇', null), ('571207', '571200', '黄竹镇', null), ('571208', '571200', '龙河镇', null), ('571209', '571200', '龙湖镇', null), ('571210', '571200', '龙门镇', null), ('571301', '571300', '东路镇', null), ('571302', '571300', '东郊镇', null), ('571303', '571300', '东阁镇', null), ('571304', '571300', '会文镇', null), ('571305', '571300', '公坡镇', null), ('571306', '571300', '冯坡镇', null), ('571307', '571300', '抱罗镇', null), ('571308', '571300', '文城镇', null), ('571309', '571300', '文教镇', null), ('571310', '571300', '昌洒镇', null), ('571311', '571300', '潭牛镇', null), ('571312', '571300', '翁田镇', null), ('571313', '571300', '蓬莱镇', null), ('571314', '571300', '重兴镇', null), ('571315', '571300', '铺前镇', null), ('571316', '571300', '锦山镇', null), ('571317', '571300', '龙楼镇', null), ('571401', '571400', '万泉镇', null), ('571402', '571400', '中原镇', null), ('571403', '571400', '会山镇', null), ('571404', '571400', '博鳌镇', null), ('571405', '571400', '嘉积镇', null), ('571406', '571400', '塔洋镇', null), ('571407', '571400', '大路镇', null), ('571408', '571400', '彬村山华侨农场', null), ('571409', '571400', '潭门镇', null), ('571410', '571400', '石壁镇', null), ('571411', '571400', '长坡镇', null), ('571412', '571400', '阳江镇', null), ('571413', '571400', '龙江镇', null), ('571501', '571500', '万城镇', null), ('571502', '571500', '三更罗镇', null);
INSERT INTO `t_district` VALUES ('571503', '571500', '东澳镇', null), ('571504', '571500', '兴隆华侨农场', null), ('571505', '571500', '北大镇', null), ('571506', '571500', '南桥镇', null), ('571507', '571500', '后安镇', null), ('571508', '571500', '和乐镇', null), ('571509', '571500', '地方国营六连林场', null), ('571510', '571500', '大茂镇', null), ('571511', '571500', '山根镇', null), ('571512', '571500', '礼纪镇', null), ('571513', '571500', '长丰镇', null), ('571514', '571500', '龙滚镇', null), ('571601', '571600', '乌坡镇', null), ('571602', '571600', '南吕镇', null), ('571603', '571600', '南坤镇', null), ('571604', '571600', '坡心镇', null), ('571605', '571600', '屯城镇', null), ('571606', '571600', '新兴镇', null), ('571607', '571600', '枫木镇', null), ('571608', '571600', '西昌镇', null), ('571700', '571700', '白马井镇', null), ('571701', '571700', '大成镇', null), ('571702', '571700', '东成镇', null), ('571703', '571700', '峨蔓镇', null), ('571704', '571700', '光村镇', null), ('571705', '571700', '国营八一农场', null), ('571706', '571700', '国营蓝洋农场', null), ('571707', '571700', '国营西联农场', null), ('571708', '571700', '国营西培农场', null), ('571709', '571700', '海头镇', null), ('571710', '571700', '和庆镇', null), ('571711', '571700', '华南热作学院', null), ('571712', '571700', '兰洋镇', null), ('571713', '571700', '木棠镇', null), ('571714', '571700', '南丰镇', null), ('571715', '571700', '那大镇', null), ('571716', '571700', '排浦镇', null), ('571717', '571700', '三都镇', null), ('571718', '571700', '王五镇', null), ('571719', '571700', '新州镇', null), ('571720', '571700', '雅星镇', null), ('571721', '571700', '洋浦经济开发区', null), ('571722', '571700', '中和镇', null), ('571801', '571800', '东英镇', null), ('571802', '571800', '临城镇', null), ('571803', '571800', '南宝镇', null), ('571804', '571800', '博厚镇', null), ('571805', '571800', '和舍镇', null), ('571806', '571800', '国营加来农场', null), ('571807', '571800', '多文镇', null), ('571808', '571800', '新盈镇', null), ('571809', '571800', '波莲镇', null), ('571810', '571800', '皇桐镇', null), ('571811', '571800', '调楼镇', null), ('571901', '571900', '中兴镇', null), ('571902', '571900', '仁兴镇', null), ('571903', '571900', '加乐镇', null), ('571904', '571900', '国营金安农场', null), ('571905', '571900', '大丰镇', null), ('571906', '571900', '文儒镇', null), ('571907', '571900', '桥头镇', null), ('571908', '571900', '永发镇', null), ('571909', '571900', '瑞溪镇', null), ('571910', '571900', '福山镇', null), ('571911', '571900', '老城镇', null), ('571912', '571900', '金江镇', null), ('572001', '572000', '吉阳区', null), ('572002', '572000', '天涯区', null), ('572003', '572000', '崖州区', null), ('572004', '572000', '海棠区', null), ('572201', '572200', '南圣镇', null), ('572202', '572200', '县直辖村级区划', null), ('572203', '572200', '毛道乡', null), ('572204', '572200', '毛阳镇', null), ('572205', '572200', '水满乡', null), ('572206', '572200', '畅好乡', null), ('572207', '572200', '番阳镇', null), ('572208', '572200', '通什镇', null), ('572301', '572300', '三道镇', null), ('572302', '572300', '什玲镇', null), ('572303', '572300', '保城镇', null), ('572304', '572300', '六弓乡', null), ('572305', '572300', '加茂镇', null), ('572306', '572300', '南林乡', null), ('572307', '572300', '县直辖村级区划', null), ('572308', '572300', '响水镇', null), ('572309', '572300', '新政镇', null), ('572310', '572300', '毛感乡', null), ('572401', '572400', '三才镇', null), ('572402', '572400', '光坡镇', null), ('572403', '572400', '国营吊罗山林业公司', null), ('572404', '572400', '提蒙乡', null), ('572405', '572400', '文罗镇', null), ('572406', '572400', '新村镇', null), ('572407', '572400', '本号镇', null), ('572408', '572400', '椰林镇', null), ('572409', '572400', '群英乡', null), ('572410', '572400', '英州镇', null), ('572411', '572400', '隆广镇', null), ('572412', '572400', '黎安镇', null);
INSERT INTO `t_district` VALUES ('572501', '572500', '万冲镇', null), ('572502', '572500', '九所镇', null), ('572503', '572500', '佛罗镇', null), ('572504', '572500', '利国镇', null), ('572505', '572500', '千家镇', null), ('572506', '572500', '国营尖峰岭林业公司', null), ('572507', '572500', '国营莺歌海盐场', null), ('572508', '572500', '大安镇', null), ('572509', '572500', '尖峰镇', null), ('572510', '572500', '志仲镇', null), ('572511', '572500', '抱由镇', null), ('572512', '572500', '莺歌海镇', null), ('572513', '572500', '黄流镇', null), ('572601', '572600', '三家镇', null), ('572602', '572600', '东方华侨农场', null), ('572603', '572600', '东河镇', null), ('572604', '572600', '八所镇', null), ('572605', '572600', '四更镇', null), ('572606', '572600', '大田镇', null), ('572607', '572600', '天安乡', null), ('572608', '572600', '感城镇', null), ('572609', '572600', '新龙镇', null), ('572610', '572600', '板桥镇', null), ('572611', '572600', '江边乡', null), ('572701', '572700', '七叉镇', null), ('572702', '572700', '乌烈镇', null), ('572703', '572700', '十月田镇', null), ('572704', '572700', '叉河镇', null), ('572705', '572700', '国营霸王岭林场', null), ('572706', '572700', '昌化镇', null), ('572707', '572700', '海尾镇', null), ('572708', '572700', '王下乡', null), ('572709', '572700', '石碌镇', null), ('572801', '572800', '七坊镇', null), ('572802', '572800', '元门乡', null), ('572803', '572800', '南开乡', null), ('572804', '572800', '打安镇', null), ('572805', '572800', '牙叉镇', null), ('572806', '572800', '细水乡', null), ('572807', '572800', '荣邦乡', null), ('572808', '572800', '邦溪镇', null), ('572809', '572800', '金波乡', null), ('572810', '572800', '阜龙乡', null), ('572811', '572800', '青松乡', null), ('572901', '572900', '上安乡', null), ('572902', '572900', '中平镇', null), ('572903', '572900', '什运乡', null), ('572904', '572900', '吊罗山乡', null), ('572905', '572900', '和平镇', null), ('572906', '572900', '海南省黎母山林场（海南黎母山省级自然保护区管理站）', null), ('572907', '572900', '湾岭镇', null), ('572908', '572900', '红毛镇', null), ('572909', '572900', '营根镇', null), ('572910', '572900', '长征镇', null), ('572911', '572900', '黎母山镇', null), ('573101', '573199', '中沙群岛的岛礁及其海域', null), ('573102', '573199', '南沙群岛', null), ('573103', '573199', '西沙群岛', null), ('610000', '610000', '成华区', null), ('610001', '610000', '武侯区', null), ('610002', '610000', '金牛区', null), ('610003', '610000', '锦江区', null), ('610004', '610000', '青羊区', null), ('610100', '610000', '龙泉驿区', null), ('610300', '610000', '青白江区', null), ('610400', '610000', '金堂县', null), ('610500', '610000', '新都区', null), ('611100', '610000', '温江区', null), ('611200', '610000', '崇州市', null), ('611300', '610000', '大邑县', null), ('611400', '610000', '新津县', null), ('611500', '610000', '邛崃市', null), ('611600', '610000', '蒲江县', null), ('611700', '610000', '郫县', null), ('611800', '610000', '都江堰市', null), ('611900', '610000', '彭州市', null), ('613100', '614000', '井研县', null), ('614000', '614000', '市中区', null), ('614100', '614000', '夹江县', null), ('614200', '614000', '峨眉山市', null), ('614300', '614000', '峨边彝族自治县', null), ('614400', '614000', '犍为县', null), ('614500', '614000', '沐川县', null), ('614600', '614000', '马边彝族自治县', null), ('614700', '614000', '金口河区', null), ('614800', '614000', '五通桥区', null), ('614900', '614000', '沙湾区', null), ('615000', '615000', '西昌市', null), ('615100', '615000', '会理县', null), ('615200', '615000', '会东县', null), ('615300', '615000', '普格县', null), ('615350', '615000', '布拖县', null), ('615400', '615000', '宁南县', null), ('615500', '615000', '德昌县', null), ('615600', '615000', '冕宁县', null), ('615700', '615000', '盐源县', null), ('615800', '615000', '木里藏族自治县', null), ('616150', '615000', '昭觉县', null), ('616200', '626700', '九龙县', null), ('616250', '615000', '金阳县', null);
INSERT INTO `t_district` VALUES ('616450', '615000', '美姑县', null), ('616550', '615000', '雷波县', null), ('616650', '615000', '越西县', null), ('616750', '615000', '喜德县', null), ('616850', '615000', '甘洛县', null), ('617000', '617000', '东区', null), ('617001', '617000', '仁和区', null), ('617002', '617000', '西区', null), ('617100', '617000', '盐边县', null), ('617200', '617000', '米易县', null), ('618000', '618000', '旌阳区', null), ('618100', '618000', '中江县', null), ('618200', '618000', '绵竹市', null), ('618300', '618000', '广汉市', null), ('618400', '618000', '什邡市', null), ('618500', '618000', '罗江县', null), ('620000', '620000', '东坡区', null), ('620200', '620000', '丹棱县', null), ('620300', '620000', '洪雅县', null), ('620400', '620000', '青神县', null), ('620500', '620000', '仁寿县', null), ('620800', '620000', '彭山县', null), ('621000', '621000', '涪城区', null), ('621001', '621000', '游仙区', null), ('621100', '621000', '三台县', null), ('621600', '621000', '盐亭县', null), ('621700', '621000', '江油市', null), ('622150', '621000', '梓潼县', null), ('622550', '621000', '平武县', null), ('622650', '621000', '安县', null), ('622750', '621000', '北川羌族自治县', null), ('623000', '624000', '汶川县', null), ('623100', '624000', '理县', null), ('623200', '624000', '茂县', null), ('623300', '637000', '顺庆区', null), ('623301', '624000', '松潘县', null), ('623400', '624000', '九寨沟县', null), ('623500', '624000', '黑水县', null), ('624000', '624000', '马尔康县', null), ('624100', '624000', '金川县', null), ('624200', '624000', '小金县', null), ('624300', '626700', '理塘县', null), ('624303', '624000', '壤塘县', null), ('624400', '624000', '红原县', null), ('624500', '624000', '若尔盖县', null), ('624600', '624000', '阿坝县', null), ('624700', '814000', '久治县', null), ('625000', '625000', '雨城区', null), ('625100', '625000', '名山县', null), ('625200', '625000', '荥经县', null), ('625300', '625000', '汉源县', null), ('625400', '625000', '石棉县', null), ('625500', '625000', '天全县', null), ('625600', '625000', '芦山县', null), ('625700', '625000', '宝兴县', null), ('626000', '626700', '康定县', null), ('626100', '626700', '泸定县', null), ('626300', '626700', '丹巴县', null), ('626400', '626700', '道孚县', null), ('626500', '626700', '炉霍县', null), ('626600', '626700', '色达县', null), ('626700', '626700', '甘孜县', null), ('626800', '626700', '新龙县', null), ('627150', '626700', '白玉县', null), ('627250', '626700', '德格县', null), ('627350', '626700', '石渠县', null), ('627450', '626700', '雅江县', null), ('627650', '626700', '巴塘县', null), ('627750', '626700', '稻城县', null), ('627850', '626700', '乡城县', null), ('627950', '626700', '得荣县', null), ('628000', '628000', '元坝区', null), ('628001', '628000', '利州区', null), ('628002', '628000', '朝天区', null), ('628100', '628000', '青川县', null), ('628200', '628000', '旺苍县', null), ('628300', '628000', '剑阁县', null), ('628400', '628000', '苍溪县', null), ('629000', '629000', '安居区', null), ('629001', '629000', '船山区', null), ('629100', '629000', '蓬溪县', null), ('629200', '629000', '射洪县', null), ('629300', '629000', '大英县', null), ('635000', '635000', '达县', null), ('635001', '635000', '通川区', null), ('635100', '635000', '大竹县', null), ('635200', '635000', '渠县', null), ('635600', '636600', '南江县', null), ('636150', '635000', '宣汉县', null), ('636250', '635000', '开江县', null), ('636350', '635000', '万源市', null), ('636400', '636600', '平昌县', null), ('636600', '636600', '巴州区', null), ('636700', '636600', '通江县', null), ('637000', '610000', '双流县', null), ('637100', '637000', '高坪区', null), ('637200', '637000', '西充县', null), ('637300', '637000', '南部县', null), ('637400', '637000', '阆中市', null), ('637500', '637000', '嘉陵区', null);
INSERT INTO `t_district` VALUES ('637600', '637000', '仪陇县', null), ('637700', '637000', '营山县', null), ('637800', '637000', '蓬安县', null), ('638300', '638500', '岳池县', null), ('638400', '638500', '武胜县', null), ('638500', '638500', '邻水县', null), ('638550', '638500', '广安区', null), ('638600', '638500', '华蓥市', null), ('641008', '641000', '市中区', null), ('641100', '641000', '东兴区', null), ('641200', '641000', '资中县', null), ('641300', '641300', '雁江区', null), ('641400', '641300', '简阳市', null), ('641500', '641300', '乐至县', null), ('642150', '641000', '隆昌县', null), ('642350', '641300', '安岳县', null), ('642450', '641000', '威远县', null), ('643000', '643000', '自流井区', null), ('643010', '643000', '大安区', null), ('643020', '643000', '贡井区', null), ('643030', '643000', '沿滩区', null), ('643100', '643000', '荣县', null), ('643200', '643000', '富顺县', null), ('644000', '644000', '翠屏区', null), ('644100', '644000', '南溪县', null), ('644200', '644000', '江安县', null), ('644300', '644000', '长宁县', null), ('644400', '644000', '兴文县', null), ('644500', '644000', '珙县', null), ('644600', '644000', '宜宾县', null), ('645150', '644000', '高县', null), ('645250', '644000', '筠连县', null), ('645350', '644000', '屏山县', null), ('646000', '646000', '江阳区', null), ('646001', '646000', '龙马潭区', null), ('646100', '646000', '泸县', null), ('646200', '646000', '合江县', null), ('646300', '646000', '纳溪区', null), ('646400', '646000', '叙永县', null), ('646500', '646000', '古蔺县', null), ('650000', '650000', '五华区', null), ('650001', '650000', '盘龙区', null), ('650100', '650000', '西山区', null), ('650200', '650000', '官渡区', null), ('650300', '650000', '安宁市', null), ('650400', '650000', '富民县', null), ('650500', '650000', '呈贡县', null), ('650600', '650000', '晋宁县', null), ('651100', '653100', '易门县', null), ('651200', '675000', '禄丰县', null), ('651300', '675000', '元谋县', null), ('651400', '675000', '永仁县', null), ('651500', '650000', '禄劝彝族苗族自治县', null), ('651600', '675000', '武定县', null), ('651700', '650000', '嵩明县', null), ('652100', '650000', '宜良县', null), ('652200', '650000', '石林彝族自治县', null), ('652300', '651400', '弥勒县', null), ('652400', '651400', '泸西县', null), ('652500', '653100', '澄江县', null), ('652600', '653100', '江川县', null), ('652700', '653100', '通海县', null), ('652800', '653100', '华宁县', null), ('653100', '653100', '红塔区', null), ('653200', '653100', '峨山彝族自治县', null), ('653300', '653100', '元江哈尼族彝族傣族自治县', null), ('653400', '653100', '新平彝族傣族自治县', null), ('654100', '650000', '东川区', null), ('654200', '655000', '会泽县', null), ('654300', '651400', '建水县', null), ('654400', '651400', '红河县', null), ('654600', '657000', '巧家县', null), ('654800', '665000', '墨江哈尼族自治县', null), ('655000', '655000', '麒麟区', null), ('655100', '655000', '马龙县', null), ('655200', '650000', '寻甸回族彝族自治县', null), ('655400', '655000', '宣威市', null), ('655500', '655000', '富源县', null), ('655501', '655000', '沾益县', null), ('655600', '655000', '陆良县', null), ('655700', '655000', '师宗县', null), ('655800', '655000', '罗平县', null), ('657000', '657000', '昭阳区', null), ('657100', '657000', '鲁甸县', null), ('657200', '657000', '镇雄县', null), ('657300', '657000', '永善县', null), ('657400', '657000', '大关县', null), ('657500', '657000', '盐津县', null), ('657600', '657000', '彝良县', null), ('657700', '657000', '绥江县', null), ('657800', '657000', '水富县', null), ('657900', '657000', '威信县', null), ('661000', '651400', '个旧市', null), ('661100', '651400', '蒙自县', null), ('661200', '651400', '屏边苗族自治县', null), ('661300', '651400', '河口瑶族自治县', null), ('661500', '651400', '金平苗族瑶族傣族自治县', null), ('661600', '651400', '开远市', null), ('662200', '651400', '石屏县', null), ('662400', '651400', '元阳县', null);
INSERT INTO `t_district` VALUES ('662500', '651400', '绿春县', null), ('663000', '663000', '文山县', null), ('663100', '663000', '砚山县', null), ('663200', '663000', '丘北县', null), ('663300', '663000', '广南县', null), ('663400', '663000', '富宁县', null), ('663500', '663000', '西畴县', null), ('663600', '663000', '麻栗坡县', null), ('663700', '663000', '马关县', null), ('665000', '665000', '宁洱哈尼族彝族自治县', null), ('665001', '665000', '思茅区', null), ('665600', '665000', '澜沧拉祜族自治县', null), ('665700', '665000', '西盟佤族自治县', null), ('665800', '665000', '孟连傣族拉祜族佤族自治县', null), ('665900', '665000', '江城哈尼族彝族自治县', null), ('666100', '666100', '景洪市', null), ('666200', '666100', '勐海县', null), ('666300', '666100', '勐腊县', null), ('666400', '665000', '景谷傣族彝族自治县', null), ('666500', '665000', '镇沅彝族哈尼族拉祜族自治县', null), ('671000', '671000', '大理市', null), ('671200', '671000', '洱源县', null), ('671300', '671000', '剑川县', null), ('671400', '673100', '兰坪白族普米族自治县', null), ('671500', '671000', '鹤庆县', null), ('671600', '671000', '宾川县', null), ('672100', '671000', '祥云县', null), ('672400', '671000', '巍山彝族回族自治县', null), ('672500', '671000', '漾濞彝族自治县', null), ('672600', '671000', '永平县', null), ('672700', '671000', '云龙县', null), ('673200', '673100', '泸水县', null), ('673400', '673100', '福贡县', null), ('673500', '673100', '贡山独龙族怒族自治县', null), ('674100', '674100', '古城区', null), ('674101', '674100', '玉龙纳西族自治县', null), ('674200', '674100', '永胜县', null), ('674300', '674100', '宁蒗彝族自治县', null), ('674400', '674400', '香格里拉县', null), ('674500', '674400', '德钦县', null), ('674600', '674400', '维西傈僳族自治县', null), ('674800', '674100', '华坪县', null), ('675000', '675000', '楚雄市', null), ('675100', '675000', '双柏县', null), ('675200', '675000', '南华县', null), ('675300', '675000', '姚安县', null), ('675400', '675000', '大姚县', null), ('675500', '675000', '牟定县', null), ('675600', '671000', '弥渡县', null), ('675700', '671000', '南涧彝族自治县', null), ('675800', '677000', '云县', null), ('675900', '677000', '凤庆县', null), ('676200', '665000', '景东彝族自治县', null), ('677000', '677000', '临翔区', null), ('677300', '677000', '双江拉祜族佤族布朗族傣族自治县', null), ('677400', '677000', '沧源佤族自治县', null), ('677500', '677000', '耿马傣族佤族自治县', null), ('677600', '677000', '永德县', null), ('677700', '677000', '镇康县', null), ('678000', '678000', '隆阳区', null), ('678100', '678000', '昌宁县', null), ('678200', '678000', '施甸县', null), ('678300', '678000', '龙陵县', null), ('678400', '678400', '潞西市', null), ('678600', '678400', '瑞丽市', null), ('678700', '678400', '陇川县', null), ('679100', '678000', '腾冲县', null), ('679200', '678400', '梁河县', null), ('679300', '678400', '盈江县', null), ('710000', '710000', '新城区', null), ('710001', '710000', '阎良区', null), ('710002', '710000', '雁塔区', null), ('710003', '710000', '碑林区', null), ('710004', '710000', '莲湖区', null), ('710009', '710000', '未央区', null), ('710020', '710000', '灞桥区', null), ('710100', '710000', '长安区', null), ('710200', '710000', '高陵县', null), ('710300', '710000', '户县', null), ('710400', '710000', '周至县', null), ('710500', '710000', '蓝田县', null), ('710600', '710000', '临潼区', null), ('711200', '712000', '淳化县', null), ('711300', '712000', '旬邑县', null), ('711400', '726000', '柞水县', null), ('711500', '726000', '镇安县', null), ('711600', '725000', '宁陕县', null), ('711700', '714000', '富平县', null), ('712000', '712000', '渭城区', null), ('712001', '712000', '秦都区', null), ('712100', '712000', '杨凌区', null), ('712200', '712000', '武功县', null), ('713100', '712000', '兴平市', null), ('713200', '712000', '礼泉县', null), ('713300', '712000', '乾县', null), ('713500', '712000', '彬县', null), ('713600', '712000', '长武县', null), ('713700', '712000', '泾阳县', null), ('713800', '712000', '三原县', null), ('714000', '714000', '临渭区', null);
INSERT INTO `t_district` VALUES ('714100', '714000', '华县', null), ('714200', '714000', '华阴市', null), ('714300', '714000', '潼关县', null), ('715100', '714000', '大荔县', null), ('715200', '714000', '澄城县', null), ('715300', '714000', '合阳县', null), ('715400', '714000', '韩城市', null), ('715500', '714000', '蒲城县', null), ('715600', '714000', '白水县', null), ('715700', '716000', '黄龙县', null), ('716000', '716000', '宝塔区', null), ('716100', '716000', '甘泉县', null), ('716200', '716000', '宜川县', null), ('717100', '716000', '延长县', null), ('717200', '716000', '延川县', null), ('717300', '716000', '子长县', null), ('717400', '716000', '安塞县', null), ('717500', '716000', '志丹县', null), ('718000', '719000', '绥德县', null), ('718100', '719000', '米脂县', null), ('718200', '719000', '吴堡县', null), ('718300', '719000', '清涧县', null), ('718400', '719000', '子洲县', null), ('718500', '719000', '靖边县', null), ('718600', '719000', '定边县', null), ('719000', '712000', '永寿县', null), ('719001', '719000', '榆阳区', null), ('719200', '719000', '佳县', null), ('719201', '719000', '横山县', null), ('719300', '719000', '神木县', null), ('719400', '719000', '府谷县', null), ('721000', '721000', '渭滨区', null), ('721001', '721000', '金台区', null), ('721100', '721000', '千阳县', null), ('721200', '721000', '陇县', null), ('721300', '721000', '陈仓区', null), ('721400', '721000', '凤翔县', null), ('721500', '721000', '麟游县', null), ('721600', '721000', '太白县', null), ('721700', '721000', '凤县', null), ('722200', '721000', '扶风县', null), ('722300', '721000', '眉县', null), ('722400', '721000', '岐山县', null), ('723000', '723000', '汉台区', null), ('723100', '723000', '南郑县', null), ('723200', '723000', '城固县', null), ('723300', '723000', '洋县', null), ('723400', '723000', '佛坪县', null), ('723500', '723000', '西乡县', null), ('723600', '723000', '镇巴县', null), ('724100', '723000', '留坝县', null), ('724200', '723000', '勉县', null), ('724300', '723000', '略阳县', null), ('724400', '723000', '宁强县', null), ('725000', '725000', '汉滨区', null), ('725100', '725000', '汉阴县', null), ('725200', '725000', '石泉县', null), ('725300', '725000', '紫阳县', null), ('725400', '725000', '岚皋县', null), ('725500', '725000', '平利县', null), ('725600', '725000', '镇坪县', null), ('725700', '725000', '旬阳县', null), ('725800', '725000', '白河县', null), ('726000', '726000', '商州区', null), ('726100', '726000', '洛南县', null), ('726200', '726000', '丹凤县', null), ('726300', '726000', '商南县', null), ('726400', '726000', '山阳县', null), ('727000', '727000', '耀州区', null), ('727001', '727000', '王益区', null), ('727017', '727000', '印台区', null), ('727200', '727000', '宜君县', null), ('727300', '716000', '黄陵县', null), ('727400', '716000', '洛川县', null), ('727500', '716000', '富县', null), ('730030', '730000', '城关区', null), ('730050', '730000', '七里河区', null), ('730060', '730000', '西固区', null), ('730070', '730000', '安宁区', null), ('730080', '730000', '红古区', null), ('730100', '730000', '榆中县', null), ('730200', '730000', '皋兰县', null), ('730300', '730000', '永登县', null), ('730400', '730900', '景泰县', null), ('730500', '743000', '岷县', null), ('730503', '743000', '临洮县', null), ('730600', '730900', '靖远县', null), ('730700', '730900', '会宁县', null), ('730900', '730900', '白银区', null), ('730901', '730900', '平川区', null), ('731100', '731100', '临夏市', null), ('731200', '731100', '和政县', null), ('731300', '731100', '广河县', null), ('731400', '731100', '东乡族自治县', null), ('731500', '731100', '康乐县', null), ('731600', '731100', '永靖县', null), ('731700', '731100', '积石山保安族东乡族撒拉族自治县', null), ('731800', '731100', '临夏县', null), ('733000', '733000', '凉州区', null), ('733100', '733000', '古浪县', null);
INSERT INTO `t_district` VALUES ('733200', '733000', '天祝藏族自治县', null), ('733300', '733000', '民勤县', null), ('734000', '734000', '甘州区', null), ('734100', '734000', '山丹县', null), ('734200', '734000', '临泽县', null), ('734300', '734000', '高台县', null), ('734400', '734000', '肃南裕固族自治县', null), ('734500', '734000', '民乐县', null), ('735000', '735000', '肃州区', null), ('735101', '735100', '峪泉镇', null), ('735102', '735100', '文殊镇', null), ('735103', '735100', '新城镇', null), ('735104', '735100', '镜铁区', null), ('735105', '735100', '长城区', null), ('735106', '735100', '雄关区', null), ('735200', '735000', '玉门市', null), ('735300', '735000', '金塔县', null), ('735400', '750300', '额济纳旗', null), ('736100', '735000', '瓜州县', null), ('736200', '735000', '敦煌市', null), ('736300', '735000', '肃北蒙古族自治县', null), ('736400', '735000', '阿克塞哈萨克族自治县', null), ('737100', '737100', '金川区', null), ('737200', '737100', '永昌县', null), ('737300', '750300', '阿拉善右旗', null), ('741000', '741000', '秦州区', null), ('741001', '741000', '麦积区', null), ('741200', '741000', '甘谷县', null), ('741300', '741000', '武山县', null), ('741400', '741000', '清水县', null), ('741500', '741000', '张家川回族自治县', null), ('741600', '741000', '秦安县', null), ('742100', '742500', '西和县', null), ('742200', '742500', '礼县', null), ('742300', '742500', '徽县', null), ('742400', '742500', '两当县', null), ('742500', '742500', '成县', null), ('743000', '743000', '安定区', null), ('743300', '743000', '通渭县', null), ('743400', '744000', '静宁县', null), ('744000', '744000', '崆峒区', null), ('744100', '744000', '华亭县', null), ('744200', '744000', '崇信县', null), ('744300', '744000', '泾川县', null), ('744400', '744000', '灵台县', null), ('744500', '745000', '镇原县', null), ('744600', '744000', '庄浪县', null), ('745000', '745000', '西峰区', null), ('745100', '745000', '庆城县', null), ('745200', '745000', '宁县', null), ('745300', '745000', '正宁县', null), ('745400', '745000', '合水县', null), ('745600', '745000', '华池县', null), ('745700', '745000', '环县', null), ('746000', '742500', '武都区', null), ('746300', '747000', '舟曲县', null), ('746400', '742500', '文县', null), ('746500', '742500', '康县', null), ('747000', '747000', '合作市', null), ('747100', '747000', '夏河县', null), ('747200', '747000', '碌曲县', null), ('747300', '747000', '玛曲县', null), ('747400', '747000', '迭部县', null), ('747500', '747000', '临潭县', null), ('747600', '747000', '卓尼县', null), ('748100', '743000', '陇西县', null), ('748200', '743000', '渭源县', null), ('748300', '743000', '漳县', null), ('748500', '742500', '宕昌县', null), ('750000', '750000', '兴庆区', null), ('750001', '750000', '西夏区', null), ('750002', '750000', '金凤区', null), ('750100', '750000', '永宁县', null), ('750200', '750000', '贺兰县', null), ('750300', '750300', '阿拉善左旗', null), ('751100', '751100', '利通区', null), ('751300', '751100', '同心县', null), ('751400', '750000', '灵武市', null), ('751500', '751100', '盐池县', null), ('751600', '751100', '青铜峡市', null), ('753000', '753000', '大武口区', null), ('753400', '753000', '平罗县', null), ('753600', '753000', '惠农区', null), ('755000', '755000', '沙坡头区', null), ('755100', '755000', '中宁县', null), ('755200', '755000', '海原县', null), ('756000', '756000', '原州区', null), ('756200', '756000', '西吉县', null), ('756300', '756000', '隆德县', null), ('756400', '756000', '泾源县', null), ('756500', '756000', '彭阳县', null), ('810000', '810000', '城东区', null), ('810001', '810000', '城中区', null), ('810002', '810000', '城北区', null), ('810003', '810000', '城西区', null), ('810100', '810000', '大通回族土族自治县', null), ('810300', '812200', '门源回族自治县', null), ('810400', '812200', '祁连县', null), ('810500', '810600', '互助土族自治县', null), ('810600', '810600', '平安县', null);
INSERT INTO `t_district` VALUES ('810700', '810600', '乐都县', null), ('810800', '810600', '民和回族土族自治县', null), ('810900', '810600', '化隆回族自治县', null), ('811100', '810600', '循化撒拉族自治县', null), ('811200', '811300', '尖扎县', null), ('811300', '811300', '同仁县', null), ('811400', '811300', '泽库县', null), ('811500', '811300', '河南蒙古族自治县', null), ('811600', '810000', '湟中县', null), ('811700', '813000', '贵德县', null), ('811800', '813000', '共和县', null), ('812100', '810000', '湟源县', null), ('812200', '812200', '海晏县', null), ('812300', '812200', '刚察县', null), ('813100', '813000', '贵南县', null), ('813200', '813000', '同德县', null), ('813300', '813000', '兴海县', null), ('813500', '814000', '玛多县', null), ('814000', '814000', '玛沁县', null), ('814100', '814000', '甘德县', null), ('814200', '814000', '达日县', null), ('814300', '814000', '班玛县', null), ('815000', '815000', '玉树县', null), ('815100', '815000', '称多县', null), ('815200', '815000', '囊谦县', null), ('815300', '815000', '杂多县', null), ('815400', '815000', '治多县', null), ('815500', '815000', '曲麻莱县', null), ('816000', '817000', '格尔木市', null), ('816100', '817000', '都兰县', null), ('816201', '817000', '大柴旦', null), ('816300', '817000', '冷湖', null), ('816400', '817000', '茫崖', null), ('817000', '817000', '德令哈市', null), ('817100', '817000', '乌兰县', null), ('817200', '817000', '天峻县', null), ('830000', '830000', '乌鲁木齐县', null), ('830001', '830000', '天山区', null), ('830002', '830000', '头屯河区', null), ('830004', '830000', '水磨沟区', null), ('830007', '830000', '沙依巴克区', null), ('830009', '830000', '达坂城区', null), ('830026', '830000', '新市区', null), ('831100', '831100', '昌吉市', null), ('831200', '831100', '呼图壁县', null), ('831300', '831100', '五家渠市', null), ('831301', '831300', '人民路街道', null), ('831302', '831300', '兵团一零一团', null), ('831303', '831300', '兵团一零三团', null), ('831304', '831300', '兵团一零二团', null), ('831305', '831300', '军垦路街道', null), ('831306', '831300', '青湖路街道', null), ('831400', '830000', '米东区', null), ('831500', '831100', '阜康市', null), ('831700', '831100', '吉木萨尔县', null), ('831800', '831100', '奇台县', null), ('831900', '831100', '木垒哈萨克自治县', null), ('832001', '832000', '东城街道', null), ('832002', '832000', '兵团一五二团', null), ('832003', '832000', '北泉镇', null), ('832004', '832000', '向阳街道', null), ('832005', '832000', '新城街道', null), ('832006', '832000', '石河子镇', null), ('832007', '832000', '红山街道', null), ('832008', '832000', '老街街道', null), ('832100', '834700', '沙湾县', null), ('832200', '831100', '玛纳斯县', null), ('833008', '834700', '乌苏市', null), ('833200', '835100', '奎屯市', null), ('833300', '833400', '精河县', null), ('833400', '833400', '博乐市', null), ('833500', '833400', '温泉县', null), ('833600', '834000', '独山子区', null), ('834000', '834000', '乌尔禾区', null), ('834001', '834000', '克拉玛依区', null), ('834002', '834000', '白碱滩区', null), ('834300', '834700', '塔城市', null), ('834400', '834700', '和布克赛尔蒙古自治县', null), ('834500', '834700', '托里县', null), ('834600', '834700', '额敏县', null), ('834806', '834700', '裕民县', null), ('835000', '835100', '伊宁市', null), ('835107', '835100', '伊宁县', null), ('835200', '835100', '霍城县', null), ('835300', '835100', '察布查尔锡伯自治县', null), ('835400', '835100', '巩留县', null), ('835500', '835100', '昭苏县', null), ('835501', '835100', '特克斯县', null), ('835700', '835100', '尼勒克县', null), ('836000', '836500', '北屯镇', null), ('836100', '836500', '富蕴县', null), ('836200', '836500', '青河县', null), ('836400', '836500', '福海县', null), ('836500', '836500', '阿勒泰市', null), ('836600', '836500', '布尔津县', null), ('836700', '836500', '哈巴河县', null), ('836800', '836500', '吉木乃县', null), ('838000', '838000', '吐鲁番市', null), ('838100', '838000', '托克逊县', null), ('838200', '838000', '鄯善县', null);
INSERT INTO `t_district` VALUES ('839000', '839000', '哈密市', null), ('839200', '839000', '巴里坤哈萨克自治县', null), ('839300', '839000', '伊吾县', null), ('841000', '841000', '库尔勒市', null), ('841007', '841007', '博古其镇', null), ('841017', '841007', '双丰镇', null), ('841100', '841000', '焉耆回族自治县', null), ('841200', '841000', '和硕县', null), ('841300', '841000', '和静县', null), ('841400', '841000', '博湖县', null), ('841500', '841000', '尉犁县', null), ('841600', '841000', '轮台县', null), ('841800', '841000', '若羌县', null), ('841900', '841000', '且末县', null), ('842000', '843000', '库车县', null), ('842100', '843000', '新和县', null), ('842200', '843000', '沙雅县', null), ('842300', '843000', '拜城县', null), ('843000', '843000', '阿克苏市', null), ('843100', '843000', '温宿县', null), ('843200', '843000', '阿瓦提县', null), ('843301', '843300', '兵团一团', null), ('843302', '843300', '兵团七团', null), ('843303', '843300', '兵团三团', null), ('843304', '843300', '兵团九团', null), ('843305', '843300', '兵团二团', null), ('843306', '843300', '兵团五团', null), ('843307', '843300', '兵团八团', null), ('843308', '843300', '兵团六团', null), ('843309', '843300', '兵团农一师沙井子水利管理处', null), ('843310', '843300', '兵团十一团', null), ('843311', '843300', '兵团十三团', null), ('843312', '843300', '兵团十二团', null), ('843313', '843300', '兵团十六团', null), ('843314', '843300', '兵团十四团', null), ('843315', '843300', '兵团十团', null), ('843316', '843300', '兵团四团', null), ('843317', '843300', '兵团第一师塔里木灌区水利管理处', null), ('843318', '843300', '兵团第一师水利水电工程处', null), ('843319', '843300', '南口街道', null), ('843320', '843300', '工业园区', null), ('843321', '843300', '幸福路街道', null), ('843322', '843300', '托喀依乡', null), ('843323', '843300', '西工业园区管理委员会', null), ('843324', '843300', '金银川路街道', null), ('843325', '843300', '青松路街道', null), ('843400', '843000', '乌什县', null), ('843500', '845350', '阿合奇县', null), ('843600', '843000', '柯坪县', null), ('843800', '844000', '巴楚县', null), ('843901', '843900', '兵团五十一团', null), ('843902', '843900', '兵团五十三团', null), ('843903', '843900', '兵团五十团', null), ('843904', '843900', '兵团四十一团', null), ('843905', '843900', '兵团四十九团', null), ('843906', '843900', '兵团四十四团', null), ('843907', '843900', '兵团图木舒克市喀拉拜勒镇', null), ('843908', '843900', '前海街道', null), ('843909', '843900', '永安坝街道', null), ('843910', '843900', '齐干却勒街道', null), ('844000', '844000', '喀什市', null), ('844100', '844000', '疏附县', null), ('844200', '844000', '疏勒县', null), ('844300', '844000', '伽师县', null), ('844400', '844000', '岳普湖县', null), ('844508', '844000', '英吉沙县', null), ('844600', '844000', '麦盖提县', null), ('844700', '844000', '莎车县', null), ('844800', '844000', '泽普县', null), ('844900', '835100', '新源县', null), ('844901', '844000', '叶城县', null), ('845150', '848000', '皮山县', null), ('845250', '844000', '塔什库尔干塔吉克自治县', null), ('845350', '845350', '阿图什市', null), ('845450', '845350', '乌恰县', null), ('845550', '845350', '阿克陶县', null), ('848000', '848000', '和田县', null), ('848001', '848000', '和田市', null), ('848100', '848000', '墨玉县', null), ('848200', '848000', '洛浦县', null), ('848300', '848000', '策勒县', null), ('848400', '848000', '于田县', null), ('848500', '848000', '民丰县', null), ('850100', '850000', '达孜县', null), ('850200', '850000', '墨竹工卡县', null), ('850600', '850000', '曲水县', null), ('850700', '856000', '贡嘎县', null), ('850800', '856000', '扎囊县', null), ('851100', '856000', '浪卡子县', null), ('851200', '856000', '洛扎县', null), ('851400', '850000', '堆龙德庆县', null), ('851500', '850000', '当雄县', null), ('851600', '850000', '尼木县', null), ('851611', '850000', '林周县', null), ('852000', '852000', '那曲县', null), ('852100', '852000', '巴青县', null), ('852200', '852000', '索县', null), ('852300', '852000', '比如县', null), ('852400', '852000', '嘉黎县', null), ('852500', '852000', '班戈县', null);
INSERT INTO `t_district` VALUES ('853100', '852000', '申扎县', null), ('853200', '852000', '尼玛县', null), ('853400', '852000', '安多县', null), ('853500', '852000', '聂荣县', null), ('854000', '854000', '昌都县', null), ('854100', '854000', '江达县', null), ('854200', '854000', '贡觉县', null), ('854300', '854000', '察雅县', null), ('854400', '854000', '左贡县', null), ('854500', '854000', '芒康县', null), ('854600', '854000', '八宿县', null), ('855400', '854000', '洛隆县', null), ('855500', '854000', '边坝县', null), ('855600', '854000', '类乌齐县', null), ('855700', '854000', '丁青县', null), ('856100', '856000', '乃东县', null), ('856200', '856000', '桑日县', null), ('856300', '856000', '曲松县', null), ('856400', '856000', '加查县', null), ('856600', '856000', '隆子县', null), ('856700', '856000', '错那县', null), ('856800', '856000', '琼结县', null), ('856900', '856000', '措美县', null), ('857000', '857000', '日喀则市', null), ('857100', '857000', '南木林县', null), ('857200', '857000', '仁布县', null), ('857300', '857000', '白朗县', null), ('857400', '857000', '江孜县', null), ('857500', '857000', '康马县', null), ('857600', '857000', '亚东县', null), ('857700', '857000', '岗巴县', null), ('857800', '857000', '萨迦县', null), ('857900', '857000', '定结县', null), ('858100', '857000', '拉孜县', null), ('858200', '857000', '定日县', null), ('858300', '857000', '聂拉木县', null), ('858500', '857000', '昂仁县', null), ('858600', '857000', '萨嘎县', null), ('858700', '857000', '吉隆县', null), ('858800', '857000', '仲巴县', null), ('858900', '857000', '谢通门县', null), ('859000', '859000', '噶尔县', null), ('859100', '859000', '革吉县', null), ('859200', '859000', '改则县', null), ('859300', '859000', '措勤县', null), ('859500', '859000', '普兰县', null), ('859600', '859000', '札达县', null), ('859700', '859000', '日土县', null), ('860100', '860000', '林芝县', null), ('860200', '860000', '工布江达县', null), ('860300', '860000', '波密县', null), ('860400', '860000', '朗县', null), ('860500', '860000', '米林县', null), ('860600', '860000', '察隅县', null), ('860700', '860000', '墨脱县', null), ('999001', '999077', '中西区', null), ('999002', '999077', '东区', null), ('999003', '999077', '南区', null), ('999004', '999077', '湾仔区', null), ('999005', '999077', '九龙城区', null), ('999006', '999077', '观塘区', null), ('999007', '999077', '深水埗区', null), ('999008', '999077', '黄大仙区', null), ('999009', '999077', '油尖旺区', null), ('999010', '999077', '离岛区', null), ('999011', '999077', '北区', null), ('999012', '999077', '西贡区', null), ('999013', '999077', '沙田区', null), ('999014', '999077', '大埔区', null), ('999015', '999077', '屯门区', null), ('999016', '999077', '元朗区', null), ('999017', '999077', '荃湾区', null), ('999018', '999077', '葵青区', null), ('999021', '999078', '花地玛堂区', null), ('999022', '999078', '圣安多尼堂区', null), ('999023', '999078', '大堂区', null), ('999024', '999078', '望德堂区', null), ('999025', '999078', '风顺堂区', null), ('999026', '999078', '嘉模堂区', null), ('999027', '999078', '圣方济各堂区', null), ('999028', '999078', '路氹城', null);
COMMIT;

-- ----------------------------
-- Table structure for `t_login_audit_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_login_audit_log`;
CREATE TABLE `t_login_audit_log` (
`log_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志ID' ,
`login_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号' ,
`ip`  varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址' ,
`is_lan`  int(1) NOT NULL DEFAULT 0 COMMENT '是否局域网' ,
`user_agent`  varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '浏览器UA' ,
`os`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统' ,
`type`  int(1) NOT NULL DEFAULT 1 COMMENT '类型(1=登入；2=登出)' ,
`log_time`  datetime NOT NULL COMMENT '日志时间' ,
PRIMARY KEY (`log_id`),
INDEX `idx_login_name` (`login_name`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='登录审计日志'

;

-- ----------------------------
-- Records of t_login_audit_log
-- ----------------------------
BEGIN;
INSERT INTO `t_login_audit_log` VALUES ('24090238180813000009', 'admin', '127.0.0.1', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0', 'Windows', '2', '2024-09-02 10:36:01'), ('24090238187660000009', 'admin', '127.0.0.1', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0', 'Windows', '1', '2024-09-02 10:36:08'), ('24090238235643000009', 'admin', '127.0.0.1', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0', 'Windows', '1', '2024-09-02 10:36:56'), ('24090238238464000009', 'admin', '127.0.0.1', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0', 'Windows', '2', '2024-09-02 10:36:59'), ('24090238240855000009', 'admin', '127.0.0.1', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0', 'Windows', '1', '2024-09-02 10:37:01');
COMMIT;

-- ----------------------------
-- Table structure for `t_province`
-- ----------------------------
DROP TABLE IF EXISTS `t_province`;
CREATE TABLE `t_province` (
`province_id`  varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省ID' ,
`province_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省名称' ,
`flag`  int(1) NOT NULL DEFAULT 2 COMMENT '标识(1=直辖市；2=省；3=自治区；4=特别行政区)' ,
`remark`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`province_id`),
INDEX `idx_flag` (`flag`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='省'

;

-- ----------------------------
-- Records of t_province
-- ----------------------------
BEGIN;
INSERT INTO `t_province` VALUES ('000222', '台湾省', '2', '中国宝岛'), ('010000', '内蒙古自治区', '3', null), ('030000', '山西省', '2', null), ('050000', '河北省', '2', null), ('100000', '北京市', '1', '首都'), ('110000', '辽宁省', '2', null), ('130000', '吉林省', '2', null), ('150000', '黑龙江省', '2', null), ('200000', '上海市', '1', null), ('210000', '江苏省', '2', null), ('230000', '安徽省', '2', null), ('250000', '山东省', '2', null), ('300000', '天津市', '1', null), ('310000', '浙江省', '2', null), ('330000', '江西省', '2', ''), ('350000', '福建省', '2', null), ('400000', '重庆市', '1', null), ('410000', '湖南省', '2', null), ('430000', '湖北省', '2', null), ('450000', '河南省', '2', null), ('510000', '广东省', '2', null), ('530000', '广西壮族自治区', '3', null), ('550000', '贵州省', '2', null), ('570100', '海南省', '2', null), ('610000', '四川省', '2', null), ('650000', '云南省', '2', null), ('710000', '陕西省', '2', null), ('730000', '甘肃省', '2', null), ('750000', '宁夏回族自治区', '3', null), ('810000', '青海省', '2', null), ('830000', '新疆维吾尔自治区', '3', null), ('850000', '西藏自治区', '3', null), ('999000', '港、澳特别行政区', '4', null);
COMMIT;

-- ----------------------------
-- Table structure for `t_sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_menu`;
CREATE TABLE `t_sys_menu` (
`menu_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID' ,
`menu_name`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称' ,
`menu_alias`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单别名' ,
`parent_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父菜单ID' ,
`menu_type`  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单类型(M=菜单；F=功能按钮)' ,
`icon`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标' ,
`url`  varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求URL' ,
`target`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '_self' COMMENT '打开方式' ,
`visible`  int(1) NULL DEFAULT 1 COMMENT '菜单显隐状态(1=显示；0=隐藏)' ,
`order_num`  int(4) NULL DEFAULT 1 COMMENT '显示顺序' ,
`remark`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`create_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
PRIMARY KEY (`menu_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='菜单权限'

;

-- ----------------------------
-- Records of t_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_menu` VALUES ('22021220851349000138', '系统管理', '系统管理', '0', 'M', 'mdi-view-dashboard', null, '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:47:29', '22013040950847000084', '2022-02-12 17:47:29'), ('22021220868051000138', '用户管理', '用户管理', '22021220851349000138', 'M', '', '/system/user/view', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:47:45', '22013040950847000084', '2022-03-13 21:54:00'), ('22021220879115000138', '角色管理', '角色管理', '22021220851349000138', 'M', null, '/system/role/view', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:47:57', '22013040950847000084', '2022-02-12 17:47:57'), ('22021220896714000138', '菜单管理', '菜单管理', '22021220851349000138', 'M', '', '/system/menu/view', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:48:14', '22013040950847000084', '2022-05-16 14:28:17'), ('22021220927630000138', '列表', '列表', '22021220868051000138', 'F', null, '/system/user/list', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:48:45', '22013040950847000084', '2022-02-12 17:48:45'), ('22021220938979000138', '新增', '新增', '22021220868051000138', 'F', null, '/system/user/save', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:48:56', '22013040950847000084', '2022-06-02 22:29:52'), ('22021220948854000138', '修改', '修改', '22021220868051000138', 'F', null, '/system/user/update', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:49:06', '22013040950847000084', '2022-06-02 22:29:54'), ('22021220958161000138', '删除', '删除', '22021220868051000138', 'F', null, '/system/user/del', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:49:16', '22013040950847000084', '2022-02-12 17:49:16'), ('22021220969051000138', '查询明细', '查询明细', '22021220868051000138', 'F', null, '/system/user/single', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:49:26', '22013040950847000084', '2022-02-12 17:49:26'), ('22021220981781000138', '赋权列表', '赋权列表', '22021220868051000138', 'F', null, '/system/user/grant/list', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:49:39', '22013040950847000084', '2022-02-12 17:49:39'), ('22021220994555000138', '新增赋权', '新增赋权', '22021220868051000138', 'F', null, '/system/user/grant/save', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:49:52', '22013040950847000084', '2022-02-12 17:49:52'), ('22021221006012000138', '删除赋权', '删除赋权', '22021220868051000138', 'F', null, '/system/user/grant/del', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:50:03', '22013040950847000084', '2022-02-12 17:50:03'), ('22021221023125000138', '列表', '列表', '22021220879115000138', 'F', null, '/system/role/list', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:50:21', '22013040950847000084', '2022-02-12 17:50:21'), ('22021221030073000138', '新增', '新增', '22021220879115000138', 'F', null, '/system/role/save', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:50:27', '22013040950847000084', '2022-02-12 17:50:27'), ('22021221038308000138', '修改', '修改', '22021220879115000138', 'F', null, '/system/role/update', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:50:36', '22013040950847000084', '2022-02-12 17:50:36'), ('22021221046144000138', '删除', '删除', '22021220879115000138', 'F', null, '/system/role/del', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:50:44', '22013040950847000084', '2022-02-12 17:50:44'), ('22021221060910000138', '查询明细', '查询明细', '22021220879115000138', 'F', null, '/system/role/single', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:50:58', '22013040950847000084', '2022-02-12 17:50:58'), ('22021221071941000138', '权限分配', '权限分配', '22021220879115000138', 'F', null, '/system/role/grant/save', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:51:09', '22013040950847000084', '2022-02-12 17:51:09'), ('22021221088773000138', '列表', '列表', '22021220896714000138', 'F', null, '/system/menu/list', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:51:26', '22013040950847000084', '2022-02-12 17:51:26'), ('22021221095314000138', '新增', '新增', '22021220896714000138', 'F', null, '/system/menu/save', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:51:33', '22013040950847000084', '2022-02-12 17:51:33'), ('22021221102773000138', '修改', '修改', '22021220896714000138', 'F', null, '/system/menu/update', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:51:40', '22013040950847000084', '2022-02-12 17:51:40'), ('22021221109589000138', '删除', '删除', '22021220896714000138', 'F', null, '/system/menu/del', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:51:47', '22013040950847000084', '2022-02-12 17:51:47'), ('22021221121678000138', '查询明细', '查询明细', '22021220896714000138', 'F', null, '/system/menu/single', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:51:59', '22013040950847000084', '2022-02-12 17:51:59'), ('22021221133622000138', '新增权限', '新增权限', '22021220896714000138', 'F', null, '/system/menu/func/save', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:52:11', '22013040950847000084', '2022-02-12 17:52:11'), ('22021221145219000138', '修改权限', '修改权限', '22021220896714000138', 'F', null, '/system/menu/func/update', '_self', '1', '1', null, '22013040950847000084', '2022-02-12 17:52:23', '22013040950847000084', '2022-02-12 17:52:23'), ('22041415996518000024', '行政区管理', '行政区管理', '0', 'M', 'mdi-city', null, '_self', '1', '2', '', '22013040950847000084', '2022-04-14 16:26:36', '22013040950847000084', '2023-08-10 15:13:52'), ('22041416045864000024', '省/直辖市', '省/直辖市', '22041415996518000024', 'M', '', '/area/province/view', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 16:27:25', '22013040950847000084', '2022-04-14 17:08:20'), ('22041416066230000024', '城市', '城市', '22041415996518000024', 'M', '', '/area/city/view', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 16:27:45', '22013040950847000084', '2022-04-14 17:08:32'), ('22041416084703000024', '区县', '区县', '22041415996518000024', 'M', '', '/area/district/view', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 16:28:03', '22013040950847000084', '2022-09-15 16:50:16'), ('22041419902110000024', '列表', '列表', '22041416045864000024', 'F', null, '/area/province/list', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:31:41', '22013040950847000084', '2022-10-19 22:24:42'), ('22041419910403000024', '新增', '新增', '22041416045864000024', 'F', null, '/area/province/save', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:31:49', '22013040950847000084', '2022-04-14 17:31:49'), ('22041419919378000024', '修改', '修改', '22041416045864000024', 'F', null, '/area/province/update', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:31:58', '22013040950847000084', '2022-04-14 17:31:58'), ('22041419929941000024', '删除', '删除', '22041416045864000024', 'F', null, '/area/province/del', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:32:09', '22013040950847000084', '2022-04-14 17:32:09'), ('22041419948401000024', '查询明细', '查询明细', '22041416045864000024', 'F', null, '/area/province/single', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:32:27', '22013040950847000084', '2022-04-14 17:32:27'), ('22041419978718000024', '列表', '列表', '22041416066230000024', 'F', null, '/area/city/list', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:32:57', '22013040950847000084', '2022-04-14 17:34:51'), ('22041419987962000024', '新增', '新增', '22041416066230000024', 'F', null, '/area/city/save', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:33:07', '22013040950847000084', '2022-04-14 17:34:56'), ('22041419995058000024', '修改', '修改', '22041416066230000024', 'F', null, '/area/city/update', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:33:14', '22013040950847000084', '2022-04-14 17:35:02'), ('22041420022221000024', '列表', '列表', '22041416084703000024', 'F', null, '/area/district/list', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:33:41', '22013040950847000084', '2022-04-14 17:33:41'), ('22041420028066000024', '新增', '新增', '22041416084703000024', 'F', null, '/area/district/save', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:33:47', '22013040950847000084', '2022-04-14 17:33:47'), ('22041420037083000024', '修改', '修改', '22041416084703000024', 'F', null, '/area/district/update', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:33:56', '22013040950847000084', '2022-04-14 17:33:56'), ('22041420048084000024', '删除', '删除', '22041416084703000024', 'F', null, '/area/district/del', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:34:07', '22013040950847000084', '2022-04-14 17:34:07'), ('22041420056307000024', '查询明细', '查询明细', '22041416084703000024', 'F', null, '/area/district/single', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:34:15', '22013040950847000084', '2022-04-14 17:34:15'), ('22041420113603000024', '删除', '删除', '22041416066230000024', 'F', null, '/area/city/del', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:35:12', '22013040950847000084', '2022-04-14 17:35:12'), ('22041420122459000024', '查询明细', '查询明细', '22041416066230000024', 'F', null, '/area/city/single', '_self', '1', '1', null, '22013040950847000084', '2022-04-14 17:35:21', '22013040950847000084', '2022-04-14 17:35:21'), ('22061918401511000170', '重置密码', '重置密码', '22021220868051000138', 'F', null, '/system/user/password/reset', '_self', '1', '1', null, '22013040950847000084', '2022-06-19 17:06:33', '22013040950847000084', '2022-06-19 17:06:44'), ('22072136007631000012', '登录互踢', '登录互踢', '22021220868051000138', 'F', null, '/system/user/set/kickout', '_self', '1', '1', null, '22013040950847000084', '2022-07-21 22:00:05', '22013040950847000084', '2022-07-21 22:00:05'), ('22101462967258000007', '数据字典', '数据字典', '22021220851349000138', 'M', '', '/system/dict/view', '_self', '1', '1', '', '22072134602356000007', '2022-10-14 15:33:43', '22072134602356000007', '2022-10-14 15:33:57'), ('22101463243689000007', '列表', '列表', '22101462967258000007', 'F', null, '/system/dict/list', '_self', '1', '1', null, '22072134602356000007', '2022-10-14 15:38:42', '22072134602356000007', '2022-10-14 15:39:16'), ('22101463281783000007', '新增', '新增', '22101462967258000007', 'F', null, '/system/dict/save', '_self', '1', '1', null, '22072134602356000007', '2022-10-14 15:39:24', '22072134602356000007', '2022-10-14 15:39:24'), ('22101463290842000007', '修改', '修改', '22101462967258000007', 'F', null, '/system/dict/update', '_self', '1', '1', null, '22072134602356000007', '2022-10-14 15:39:34', '22072134602356000007', '2022-10-14 15:39:34'), ('22101463298891000007', '删除', '删除', '22101462967258000007', 'F', null, '/system/dict/del', '_self', '1', '1', null, '22072134602356000007', '2022-10-14 15:39:42', '22072134602356000007', '2022-10-14 15:39:42'), ('22101469476356000007', '字典项列表', '字典项列表', '22101462967258000007', 'F', null, 'dictView', '_self', '1', '1', null, '22013040950847000084', '2022-10-14 17:31:15', '22013040950847000084', '2022-10-16 00:17:04'), ('22101601044904000030', '字典项维护', '字典项维护', '22101462967258000007', 'F', null, '/system/dict/item/merge', '_self', '1', '1', null, '22013040950847000084', '2022-10-16 00:17:15', '22013040950847000084', '2022-10-16 00:17:15'), ('22101860825493000026', '刷新字典缓存', '刷新字典缓存', '22101462967258000007', 'F', null, '/system/dict/reload', '_self', '1', '1', null, '22013040950847000084', '2022-10-18 16:53:45', '22013040950847000084', '2022-10-18 16:53:45'), ('22102453792887000026', '日志管理', '日志管理', '0', 'M', 'mdi-note-edit', null, '_self', '1', '2', null, '22013040950847000084', '2022-10-24 14:56:32', '22013040950847000084', '2023-05-26 11:44:21'), ('22102453820050000026', '登录日志', '登录日志', '22102453792887000026', 'M', '', '/log/login/view', '_self', '1', '1', '', '22013040950847000084', '2022-10-24 14:56:59', '22013040950847000084', '2022-10-24 14:57:36'), ('22102453888699000026', '列表', '列表', '22102453820050000026', 'F', null, '/log/login/list', '_self', '1', '1', null, '22013040950847000084', '2022-10-24 14:58:07', '22013040950847000084', '2023-05-26 11:45:04'), ('22102453910398000026', '删除', '删除', '22102453820050000026', 'F', null, '/log/login/del', '_self', '1', '1', null, '22013040950847000084', '2022-10-24 14:58:29', '22013040950847000084', '2022-10-24 14:58:29'), ('23012649676117000040', '外链', '外链', '0', 'M', 'mdi-view-dashboard', null, '_self', '1', '1', null, '22013040950847000084', '2023-01-26 13:47:56', '22013040950847000084', '2024-08-01 16:23:55'), ('23012649697566000040', '百度', '百度', '23012649676117000040', 'M', '', 'https://www.baidu.com', '_blank', '1', '1', '', '22013040950847000084', '2023-01-26 13:48:17', '22013040950847000084', '2023-01-26 13:57:00');
COMMIT;

-- ----------------------------
-- Table structure for `t_sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
`role_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID' ,
`role_name`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称' ,
`home_action`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认首页' ,
`remark`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`create_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
PRIMARY KEY (`role_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='角色'

;

-- ----------------------------
-- Records of t_sys_role
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role` VALUES ('22021240564408000138', '超级管理员', null, '', '22013040950847000084', '2022-02-12 23:16:02', '22013040950847000084', '2024-03-08 17:42:19');
COMMIT;

-- ----------------------------
-- Table structure for `t_sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_menu`;
CREATE TABLE `t_sys_role_menu` (
`role_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID' ,
`menu_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID' ,
PRIMARY KEY (`role_id`, `menu_id`),
FOREIGN KEY (`menu_id`) REFERENCES `t_sys_menu` (`menu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`role_id`) REFERENCES `t_sys_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `fk_rolemenu_ref_menu` (`menu_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='角色和菜单关联表'

;

-- ----------------------------
-- Records of t_sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_role_menu` VALUES ('22021240564408000138', '22021220868051000138'), ('22021240564408000138', '22021220879115000138'), ('22021240564408000138', '22021220896714000138'), ('22021240564408000138', '22021220927630000138'), ('22021240564408000138', '22021220938979000138'), ('22021240564408000138', '22021220948854000138'), ('22021240564408000138', '22021220958161000138'), ('22021240564408000138', '22021220969051000138'), ('22021240564408000138', '22021220981781000138'), ('22021240564408000138', '22021220994555000138'), ('22021240564408000138', '22021221006012000138'), ('22021240564408000138', '22021221023125000138'), ('22021240564408000138', '22021221030073000138'), ('22021240564408000138', '22021221038308000138'), ('22021240564408000138', '22021221046144000138'), ('22021240564408000138', '22021221060910000138'), ('22021240564408000138', '22021221071941000138'), ('22021240564408000138', '22021221088773000138'), ('22021240564408000138', '22021221095314000138'), ('22021240564408000138', '22021221102773000138'), ('22021240564408000138', '22021221109589000138'), ('22021240564408000138', '22021221121678000138'), ('22021240564408000138', '22021221133622000138'), ('22021240564408000138', '22021221145219000138'), ('22021240564408000138', '22041416045864000024'), ('22021240564408000138', '22041416066230000024'), ('22021240564408000138', '22041416084703000024'), ('22021240564408000138', '22041419902110000024'), ('22021240564408000138', '22041419910403000024'), ('22021240564408000138', '22041419919378000024'), ('22021240564408000138', '22041419929941000024'), ('22021240564408000138', '22041419948401000024'), ('22021240564408000138', '22041419978718000024'), ('22021240564408000138', '22041419987962000024'), ('22021240564408000138', '22041419995058000024'), ('22021240564408000138', '22041420022221000024'), ('22021240564408000138', '22041420028066000024'), ('22021240564408000138', '22041420037083000024'), ('22021240564408000138', '22041420048084000024'), ('22021240564408000138', '22041420056307000024'), ('22021240564408000138', '22041420113603000024'), ('22021240564408000138', '22041420122459000024'), ('22021240564408000138', '22061918401511000170'), ('22021240564408000138', '22072136007631000012'), ('22021240564408000138', '22101462967258000007'), ('22021240564408000138', '22101463243689000007'), ('22021240564408000138', '22101463281783000007'), ('22021240564408000138', '22101463290842000007'), ('22021240564408000138', '22101463298891000007'), ('22021240564408000138', '22101469476356000007'), ('22021240564408000138', '22101601044904000030'), ('22021240564408000138', '22101860825493000026'), ('22021240564408000138', '22102453820050000026'), ('22021240564408000138', '22102453888699000026'), ('22021240564408000138', '22102453910398000026');
COMMIT;

-- ----------------------------
-- Table structure for `t_sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user` (
`user_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID' ,
`login_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账号' ,
`user_type`  int(1) NULL DEFAULT 1 COMMENT '用户类型(1=系统用户；2=普通用户)' ,
`real_name`  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名' ,
`sex`  int(1) NULL DEFAULT 1 COMMENT '性别(1=男；0=女)' ,
`phone`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机' ,
`email`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱' ,
`password`  char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码' ,
`salt`  char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '盐密码' ,
`status`  int(1) NULL DEFAULT 0 COMMENT '账号状态(0=正常；1=冻结)' ,
`enable_kick_out`  int(1) NULL DEFAULT 0 COMMENT '启用登录互踢(0=禁用；1=启用)' ,
`home_action`  varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认首页' ,
`login_ip`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后登录IP' ,
`login_time`  datetime NULL DEFAULT NULL COMMENT '最后登录时间' ,
`remark`  varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注' ,
`union_id`  char(29) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信UnionID' ,
`create_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`update_user`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '更新时间' ,
PRIMARY KEY (`user_id`),
UNIQUE INDEX `idx_login_name` (`login_name`) USING BTREE ,
INDEX `idx_union_id` (`union_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='用户'

;

-- ----------------------------
-- Records of t_sys_user
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user` VALUES ('22013040950847000084', 'admin', '1', '管理员', '0', null, null, '5F147F45888267C2B9A52D48CEB047BC', '31e2e562a19e40bcb1f30f6cad5b2dfd', '0', '1', null, '127.0.0.1', '2025-03-26 18:06:00', null, null, '22013040950847000084', '2023-05-26 10:07:49', '22013040950847000084', '2025-03-26 18:06:00');
COMMIT;

-- ----------------------------
-- Table structure for `t_sys_user_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_menu`;
CREATE TABLE `t_sys_user_menu` (
`user_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID' ,
`menu_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID' ,
PRIMARY KEY (`user_id`, `menu_id`),
FOREIGN KEY (`menu_id`) REFERENCES `t_sys_menu` (`menu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `t_sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `fk_usermenu_ref_menu` (`menu_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='用户和菜单关联表'

;

-- ----------------------------
-- Records of t_sys_user_menu
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_role`;
CREATE TABLE `t_sys_user_role` (
`user_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID' ,
`role_id`  char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID' ,
PRIMARY KEY (`user_id`, `role_id`),
FOREIGN KEY (`role_id`) REFERENCES `t_sys_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
FOREIGN KEY (`user_id`) REFERENCES `t_sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `fk_userole_ref_role` (`role_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='用户和角色关联表'

;

-- ----------------------------
-- Records of t_sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `t_sys_user_role` VALUES ('22013040950847000084', '22021240564408000138');
COMMIT;
